Navigation Menu

[JD Kromkowski]

On 10/07/13 5:21 AM, Ian Macpherson wrote:
> You have to put guisimpolserver.exe & the associated icon in the simpolbin
> folder

Ian is correct.

I also just create a .bat file like this

rem first server script
cd C:SIMPOLbin
guisimpolserver.exe C:SIMPOLUtilitiessimpolserversample.cfg

And then I don't have to fool around with typing in the cmd window. And
I can create different .bats reference different .cfg s.

JDK

[JD Kromkowski]

On 10/04/13 3:03 PM, JV wrote:
> Anyone trying to automate MS Word thru wxautomation successfully?
> Got all working (thanks Ian!) except for syntax to close a document
> without saving.
> Any ideas will be greatly appreciated.
> Jean Vallee

http://msdn.microsoft.com/en-us/library/af6z0wa2(v=vs.110).aspx

may be helpful. We still use WordPerfect.

[JD Kromkowski]

Basically the same tables I sent you on 9/17 in other thread

"Re: PPCS instead of SBME in appframework application – bug!"

On 09/30/13 10:18 AM, Neil Robinson wrote:
> On 27/09/2013 18:27, kromkowski wrote:
>> See attached quickreport JDK002.sqx which I created programmatically
>> via a user interface.
>>
>> But it will not run properly programmatically:
>>
>> Error with select expression
>> select clause: identifiers not found or not unique:
>> EMPLOYEE (0)
>> Rate (0)
>>
>>
>> In PERSONAL,
>>
>> if I open the datasources and tables as sbme1, I can load and run
>> JDK002.sxq no problem.
>>
>> if I open datasource and tables as ppcs, the report is obviously not
>> loading correctly (there are no columns listed but filter looks correct
>> – but no error is thrown) and if I run it I get an error regarding
>> problem with select or where clause.
>>
>>
>
> This is strange. It should work fine either way. Can you send me the two tables in question (with just enough data to try it out)?
> If there is a problem in Personal, I would liek to resolve it before release.
>
> Ciao, Neil
>

[JD Kromkowski]

See attached quickreport JDK002.sqx which I created programmatically
via a user interface.

But it will not run properly programmatically:

Error with select expression
select clause: identifiers not found or not unique:
EMPLOYEE (0)
Rate (0)

In PERSONAL,

if I open the datasources and tables as sbme1, I can load and run
JDK002.sxq no problem.

if I open datasource and tables as ppcs, the report is obviously not
loading correctly (there are no columns listed but filter looks correct
– but no error is thrown) and if I run it I get an error regarding
problem with select or where clause.

[JD Kromkowski]

I stumbled upon this (app.datasources.getfirst()) already. The problem
(or one of the problems) remains:

many tables in a SINGLE datasource – OK,
many datasources each with a single table – problems

I will bother you about the sbms and forms, I sent you AFTER 1.8 is
released.

JDK

On 09/27/13 7:27 AM, Neil Robinson wrote:
> On 20/09/2013 17:58, kromkowski wrote:
>> On 09/19/13 2:46 PM, Neil Robinson wrote:
>>> ds1 =@ qr.adddatasource(ppcstype1, "localhost:4000", ppcs, error=e)
>>
>> But how do I get the "localhost:port number" from the app or appw?
>>
>>
> If you opened a PPCS data source in the app, then it will be in the ring of data sources, in fact, chances are you will only have
> one, and it will be the first one.
>
> app.datasources.getfirst()
>
> Ciao, Neil
>

[JD Kromkowski]

On 09/19/13 2:46 PM, Neil Robinson wrote:
> ds1 =@ qr.adddatasource(ppcstype1, "localhost:4000", ppcs, error=e)

But how do I get the "localhost:port number" from the app or appw?

[JD Kromkowski]

Just as a follow-up, I have now been able to get a qr to work with a
ppcs. But as you will see below, this is a specific case where I am only
using one ppcs with one ppcstable1. I am also "directly" put in the
appropriate values rather than being able to obtain them from the app
and/or appw. I will investigate further that point.

But there are still questions that arise.

1. In the example below – which is a variation on the qr example in
tutorial dir of projects, you'll see that I saved the qr.

If later I open Personal with simpolserver running and then go to quick
reports (F5) and open the saved report, I get error 48. (which
apparently is "IP address not found".

BUT if I open Personal, then open the datasource as ppcstype, and open
the table(s) and then I use quickreports (F5) to open the saved report
it works.

I don't think that is correct behavior. I see that in
loadquickreport(),which I presume is the same as opening the saved
report in Personal, you have to pass the datasources and the tables.
But, shouldn't you be able to obtain the ds and tables directly from the
..sxq ? Upon review of the .sxq, there are some things that are curious.
First, in the programatiically created and saved sxq the datasource
entry is so generic that it is obvious that you get an error 48

<datasource>
<sourcetype>ppcstype1</sourcetype>
<source>WAGES</source>
<sqr1table>WAGES</sqr1table>
</datasource>

But this is worse. If take that same opened .sqx and save it again from
Personal.
There is NO DATASOURCE ENTRY AT ALL! It goes straight from order to
font and title!

<order></order>
<font facename="Arial Narrow" pointsize="10" weight="n" style="n"
decoration="n" />
<title>Test Report</title>

So, when you load this second saved report (and have no tables open)
nothing happens – not even an error. It just hangs. But if you happen
to open the table (or any table with the name WAGES whether ppcs or
sbme) it magically runs. Even though there is no datasource identified
in the .sqx. And if you open a WAGES table – from whereever, even the
programatically created and saved .sqx will run even though the
datasource is identified as ppcstype1 type. (presumable the table info
is really coming from parsing the select clause, right?

EXAMPLE in tutorial dir modified for ppcs

//sbme1 sbmfile1
//sbme1table table1

ppcstype1 ppcs
ppcstype1file ppcstable1

…. yadda,yadda, yadda

ppcs =@ ppcstype1.new(udpport=.nul, error=e)
ppcstable1=@ppcs.openudpfile("10.1.10.15:4000","WAGES",error=e)

…. yadda, yadda, yadda

//ds1 =@ qr.adddatasource(sbmfile1.type, "wages.sbm", sbmfile1, error=e)
ds1 =@ qr.adddatasource(ppcs.type, "WAGES", ppcs, error=e)

//qr.addtable(table1, ds1, error=e)
qr.addtable(ppcstable1, ds1, error=e)

…. yadd, yadda, yadda

savequickreport(qr, "C:SIMPOLmytest.sxq", error=e)
…..

[JD Kromkowski]

Thanks. I will take a look. But, I am creating the qr programatically
based on user input to set the various parameters like columns (select),
filter (where), order, etc. on the fly.

This is the only way to really do this because I can't do calculated
columns using personal.

Attached is a sbme1 example which works just fine. The problem is making
it work with PPCS.

I think I know what to change except when I get to here:

ds1 =@ qr.adddatasource(sbmfile1.type,"wages.sbm", sbmfile1, error=e)
qr.addtable(table1, ds1, error=e)

ds2 =@ qr.adddatasource(sbmfile2.type,"employee.sbm", sbmfile2, error=e)
qr.addtable(table2, ds2, error=e)

JDK

PS: it would be really make sense if in future releases, the type

"ppcs1file" were renamed to "ppcs1table", to create a consistency.

I know "a hobgoblin of small minds" per Emerson, but 1) I have small
mind and 2) it is really not a "foolish consistency".

JDK

On 09/17/13 7:25 AM, Neil Robinson wrote:
> On 16/09/2013 16:38, kromkowski wrote:
>> I can't seem to be able to use a quickreport initially designed with a
>> sbme datasource in a ppcs setting.
>>
>> The qr was created programatically and then saved with
>> savequickreport(qr,sxqfilename, error=e).
>>
>> It uses more than one table.
>>
>> Being able to pro grammatically create a quickreport in the PPCS app
>> context has proven a bit complicated form me. It is hard to determine
>> whether I am just a dimwit who doesn't know what he is doing, or if
>> there are bugs or just special issues.
>>
>> JDK
>>
>
>
> From one of my apps that use quick reports:
>
> string errmsg
> integer e
> array tables
>
> tables =@ appw.gettablesarray()
> errmsg = ""
> e = 0
> qr =@ loadquickreport("ninv.sxq", datasources=app.datasources, tables=tables, error=e, errortext=errmsg)
>
>
> This should hook up all of your tables to the corresponding tables in the report.
>
> Ciao, Neil
>

[JD Kromkowski]

See attached and screenshots – the data in the files is sufficiently
altered.

I can "get around the problems" by putting tables into one .sbm. But as
we discussed that really would be a corruption nightmare waiting to
happen – when I actually move from this crude test with two tables to
something more complicated with dozens of tables and 100000s of records.

Thank you for your time.

JDK

On 09/17/13 7:21 AM, Neil Robinson wrote:
> On 10/09/2013 15:52, kromkowski wrote:
>> Well, Neil, then there is bug or there is something I am missing because
>> only the mastertable data is shown in the form.
>>
>> I have Simpolserver RUNNING.
>>
>> In Personal
>>
>> I first open ppcstype1 datasource (using appropriate ip address and
>> port) AND I open both tables EMPLOYEE and WAGES.
>>
>> Now, I try to open TestForm1.sfx. No errors, BUT only the mastertable
>> data shows!
>>
>> This is same behavior if I do this pro grammatically. (mastertable data
>> show but childtable data does not show).
>
> Can you send me the form and the tables please (no data is required – you can use the command line reorganize.smp and tell it 0
> records).
>
> Ciao, Neil

[JD Kromkowski]

On 09/10/13 10:52 AM, kromkowski wrote:
> To open the table if it is an sbme1 data source, it will
> first look in the current directory, and if it is not found there it
> will look at the whole path.

Yeah, this is a bug.

If I put ALL TABLES into ONE .sbm. Then everything works.

But if I have each TABLE in a separate .sbm, then only the mastertable
data shows.

JDK

[JD Kromkowski]

Well, Neil, then there is bug or there is something I am missing because
only the mastertable data is shown in the form.

I have Simpolserver RUNNING.

In Personal

I first open ppcstype1 datasource (using appropriate ip address and
port) AND I open both tables EMPLOYEE and WAGES.

Now, I try to open TestForm1.sfx. No errors, BUT only the mastertable
data shows!

This is same behavior if I do this pro grammatically. (mastertable data
show but childtable data does not show).

JDK

On 09/09/13 3:31 PM, Neil Robinson wrote:
> On 09/09/2013 14:53, kromkowski wrote:
>> Thank you for your responses, I think perhaps I am getting down to where
>> the problem is.
>>
>> Does openformdirect() presuppose that all of the tables you plan to use
>> are in 1 datasource?
>
> No, that has nothing to do with it. appwindow.openformdirect() will send through to opendataform1() all of the data sources that
> you have already opened, and all of the tables that you have already opened. The opendataform1() function will attempt to open any
> database table that is not in the list of table objects that it receives. To open the table if it is an sbme1 data source, it will
> first look in the current directory, and if it is not found there it will look at the whole path.

[JD Kromkowski]

Thank you for your responses, I think perhaps I am getting down to where
the problem is.

Does openformdirect() presuppose that all of the tables you plan to use
are in 1 datasource?

Right now I have two .sbms.

One called employee.sbm which includes one table called EMPLOYEE.
(apart from the systables).
And one called wages.sbm which includes one table called WAGES.

I have created a test form (TestForm1) which uses these two tables
including detailblock. The datasource entries look like this:

<datasource>
<sourcetype>sbme1</sourcetype>
<source>M:SimpolProjectsPayroll4binemployee.sbm</source>
<sdf1table master="y">EMPLOYEE</sdf1table>
</datasource>
<datasource>
<sourcetype>sbme1</sourcetype>
<source>M:SimpolProjectsPayroll4binwages.sbm</source>
<sdf1table>WAGES</sdf1table>
</datasource>
<childlinks>
<sdf1link id="1">
<sourcefield>FullName</sourcefield>
<sourcetable>EMPLOYEE</sourcetable>
<targetfield>FullName</targetfield>
<targettable>WAGES</targettable>
</sdf1link>
</childlinks>

First, just using Personal to test

Simpolserver NOT running.

1. I open TestForm1.sfx. (did NOT first open ds and tables) No problem.

Simpolserver RUNNING.

1. I open TestForm1.sfx (without first opening datasource or table.)
Error 3 for both tables. (I understand this.)

2. Now, I first open ppcstype1 datasource (using appropriate ip address
and port) AND I open both tables EMPLOYEE and WAGES. Now, I try to open
TestForm1.sfx. No errors, BUT only the mastertable data shows!

Before, I go through the hoops of jamming EMPLOYEE and WAGES into one
..sbm (because I am pretty sure things will work if I do that) is that
the issue? Is this a bug, a feature or a gotcha?

This is a simple example, involving just small two tables, but in my
brain I am thinking that jamming 20 or 30 or more tables with 10s of
thousands of records into one sbm is not such a good idea?

JDK

On 09/09/13 6:40 AM, Neil Robinson wrote:
> On 06/09/2013 23:21, kromkowski wrote:
>> I pretty sure I had a conversation like this back in 2009 when there
>> were no detail blocks.
>>
>> 1. I design a form using Personal.
>>
>> In order to do this I have to open datasources and tables. Presumably,
>> I open them as sbme1, because I won't necessarily know what the ip
>> address is going to be for where this form is going to be used in a
>> multi-user application. (maybe this is where my mistake is? maybe I
>> should open as ppcs with localhost?)
>>
>> Is this correct procedure so far?
>>
>> I save the form as a form (.sfx).
>>
>> 2. Now I want to use the form I just saved in a multi-user application
>> which obviously must use ppcs.
>>
>> HOW?
>>
>> I have simpolserver running and the tables are opened as ppcstype1
>> either in Personal or programatically.
>>
>> I now open the form either in Personal or programmatically.
>>
>> The form opens, but only the master file shows up now of the
>> detailblocks show up.
>>
>> (I can work around this by opening up and editing the .sfx to reflect
>> the ip address of where the simpolserver is running. But how would I
>> know that generically in advance.)
>>
>> There must be something I am missing.
>
> Make sure that you use appwindow.openformdirect(). If you don't wish to, then have a look at the implementation of that function,
> since you will need to make sure you pass the open data sources, tables, default values, and locales to the opendataform1()
> function. remember that nothing is global, so you have to pass everything through that the function needs.
>
> Ciao, Neil
>

[JD Kromkowski]

Thank you for your responses, I think perhaps I am getting down to where
the problem is.

Does openformdirect() presuppose that all of the tables you plan to use
are in 1 datasource?

Right now I have two .sbms.

One called employee.sbm which includes one table called EMPLOYEE.
(apart from the systables).
And one called wages.sbm which includes one table called WAGES.

I have created a test form (TestForm1) which uses these two tables
including detailblock. The datasource entries look like this:

<datasource>
<sourcetype>sbme1</sourcetype>
<source>M:SimpolProjectsPayroll4binemployee.sbm</source>
<sdf1table master="y">EMPLOYEE</sdf1table>
</datasource>
<datasource>
<sourcetype>sbme1</sourcetype>
<source>M:SimpolProjectsPayroll4binwages.sbm</source>
<sdf1table>WAGES</sdf1table>
</datasource>
<childlinks>
<sdf1link id="1">
<sourcefield>FullName</sourcefield>
<sourcetable>EMPLOYEE</sourcetable>
<targetfield>FullName</targetfield>
<targettable>WAGES</targettable>
</sdf1link>
</childlinks>

First, just using Personal to test

Simpolserver NOT running.

1. I open TestForm1.sfx. No problem.

Simpolserver RUNNING.

1. I open TestForm1.sfx (without first opening datasource or table.
Error 3 for both tables.

2. I first open ppcstype1 datasource (using appropriate ip address and
port) AND I open both tables EMPLOYEE and WAGES. Now, I try to open
TestForm1.sfx. No errors, BUT only the mastertable data shows!

Before, I go through the hoops of jamming EMPLOYEE and WAGES into one
..sbm (because I am pretty sure things will work if I do that) is that
the issue? Is this a bug, a feature or a gotcha?

This is a simple example, involving just small two tables, but in my
brain I am thinking that jamming 20 or 30 or more tables with 10s of
thousands of records into one sbm is not such a good idea?

[JD Kromkowski]

On 09/06/13 11:19 AM, kromkowski wrote:
> Yesterday, no problems today:
>
> "Error 5 adding port number 4000"
>
> any ideas?

Just to followup, I tried changing port in cfg to 5000, 5001, etc.
Worked fine.

After variety of testing things, I eventually went back to try to use
port 4000, etc. After many fails, now it works.

[JD Kromkowski]

On 09/05/13 4:10 PM, Neil Robinson wrote:
> No, that is not necessary. You are on the right track. See here:
>
> src =@ me.opendatasource("ppcstype1", "10.1.10.15:4000", appw, error=e)
> t =@ appw.opendatatable(src, "EMPLOYEE", error=e)
> t =@ appw.opendatatable(src, "WAGES", error=e)

I had figured this part. In fact, this is what I was doing all alon,
except my forms were only opening the first master table, the data in
the detailblocks was not showing at all! So I thought perhaps I was not
correctly opening the additional tables.

JDK

[Author]

Posts