PPCS instead of SBME in appframework application

[Michael]

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

> 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]

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]

should I wait until v1.8 to explore this.

There definitely seemed to have been a problem using appframework and
PPCS with complicated forms where tables are not all put in the same
..sbm. (as was documented in this thread.)

JDK

On 09/17/13 12:52 PM, kromkowski wrote:
> 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
>

[Michael]

On 14/01/2014 21:42, kromkowski wrote:
> should I wait until v1.8 to explore this.
>
> There definitely seemed to have been a problem using appframework and
> PPCS with complicated forms where tables are not all put in the same
> ..sbm. (as was documented in this thread.)

When using PPCS, all tables are in one data source. When using sbme I typically put each table in its own sbm file, but I then
have to open all the tables during system initialization, before opening any forms that require database tables.

Ciao, Neil

> JDK
>
>
>
>
> On 09/17/13 12:52 PM, kromkowski wrote:
>> 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 01/15/14 12:06 PM, Neil Robinson wrote:

> When using PPCS, all tables are in one data source. When using sbme I typically put each table in its own sbm file, but I then
> have to open all the tables during system initialization, before opening any forms that require database tables.

But that is really no good, is it?

Putting 15 or 20 tables all into one datasource! That means if
something gets corrupted or otherwise messed up in one table, everything
ends up being potentially messed up.

JDK

[Michael]

On 15/01/2014 21:59, kromkowski wrote:
> On 01/15/14 12:06 PM, Neil Robinson wrote:
>
>> When using PPCS, all tables are in one data source. When using sbme I typically put each table in its own sbm file, but I then
>> have to open all the tables during system initialization, before opening any forms that require database tables.
>
>
> But that is really no good, is it?
>
> Putting 15 or 20 tables all into one datasource! That means if
> something gets corrupted or otherwise messed up in one table, everything
> ends up being potentially messed up.

You misunderstand. All of the tables are in separate *.sbm files, but when shared using PPCS, they appear to be from a single data
source. When used directly, there is one data source for each table. When used via PPCS, there is one data source (the IP address
and port number) and that contains all of the tables. At the server end, they are still all in separate files.

Ciao, Neil

[JD Kromkowski]

On 01/17/14 7:13 AM, Neil Robinson wrote:
> On 15/01/2014 21:59, kromkowski wrote:
>> On 01/15/14 12:06 PM, Neil Robinson wrote:
>>
>>> When using PPCS, all tables are in one data source. When using sbme I typically put each table in its own sbm file, but I then
>>> have to open all the tables during system initialization, before opening any forms that require database tables.
>>
>>
>> But that is really no good, is it?
>>
>> Putting 15 or 20 tables all into one datasource! That means if
>> something gets corrupted or otherwise messed up in one table, everything
>> ends up being potentially messed up.
>
> You misunderstand. All of the tables are in separate *.sbm files, but when shared using PPCS, they appear to be from a single data
> source. When used directly, there is one data source for each table. When used via PPCS, there is one data source (the IP address
> and port number) and that contains all of the tables. At the server end, they are still all in separate files.
>
> Ciao, Neil

I see what you are saying. But that means there is definitely a bug.

As I've tried to document, I can only get this to work IF I put all of
the tables in 1 .sbm. If I have separate sbms for each table and only
one datasource (i.e. the IP address and port number) the forms do not
properly show the data.

Your appframe example does not use detailblocks in the forms. The only
way I can get a ppcs appframe thing working is if I put all of the
tables into ONE sbm.

[Michael]

On 17/01/2014 17:12, kromkowski wrote:
> I see what you are saying. But that means there is definitely a bug.
>
> As I've tried to document, I can only get this to work IF I put all of
> the tables in 1 .sbm. If I have separate sbms for each table and only
> one datasource (i.e. the IP address and port number) the forms do not
> properly show the data.
>
> Your appframe example does not use detailblocks in the forms. The only
> way I can get a ppcs appframe thing working is if I put all of the
> tables into ONE sbm.

You either need to open the tables individually in advance and have them in the datasource ring for the application and the tables
ring for the appwindow, or else the form will open them as long as it can find them.

Ciao, Neil

[JD Kromkowski]

On 01/20/14 9:12 AM, Neil Robinson wrote:
> On 17/01/2014 17:12, kromkowski wrote:
>> I see what you are saying. But that means there is definitely a bug.
>>
>> As I've tried to document, I can only get this to work IF I put all of
>> the tables in 1 .sbm. If I have separate sbms for each table and only
>> one datasource (i.e. the IP address and port number) the forms do not
>> properly show the data.
>>
>> Your appframe example does not use detailblocks in the forms. The only
>> way I can get a ppcs appframe thing working is if I put all of the
>> tables into ONE sbm.
>
> You either need to open the tables individually in advance and have them in the datasource ring for the application and the tables
> ring for the appwindow, or else the form will open them as long as it can find them.
>
> Ciao, Neil

I am not sure what are saying. I do open up the tables individually in
advance. The bug is also reproduced in Personal. I showed you screen
shots. If you have a form with detailblocks – it only works correctly
if all of the tables used are in 1 sbm.

If you can show me otherwise, please do.

[JD Kromkowski]

On 01/23/14 12:12 PM, kromkowski wrote:

> I am not sure what are saying. I do open up the tables individually in
> advance. The bug is also reproduced in Personal. I showed you screen
> shots. If you have a form with detailblocks – it only works correctly
> if all of the tables used are in 1 sbm.
>
> If you can show me otherwise, please do.
>

[Author]

Posts