Hybrid system – files with calcs

[Dan Jinks]

I set up a PPCS server using the SBL sample code and SBF files. I opened one file in Simpol Personal and changes the field that is a calculated field (last change field is a date-time calculation). The change was accepted and shows as changed in the SBL programs. From this I infer that I can continue to use the current Superbase files in a hybrid system via PPCS and do not need to revise the SBL code except to modify the OPEN FILE statements to use PPCS. I only need to worry about code for calc fields on the SIMPOL side. (I have not found any virtual fields yet, mostly just concatonated keys.) For testing, this seems like a viable approach. I can wait to convert files until I am ready to archive the SBL code modules. Is this a good short-term and mid-term strategy? Are there any issues I am missing? Most importantly, can I still get Superbase PPCS 5 or 10 user licenses?

[Michael]

On 07/07/2011 21:31, djinks wrote:
> I set up a PPCS server using the SBL sample code and SBF files. I
> opened one file in Simpol Personal and changes the field that is a
> calculated field (last change field is a date-time calculation).
> The change was accepted and shows as changed in the SBL programs.
>
> From this I infer that I can continue to use the current Superbase
> files in a hybrid system via PPCS and do not need to revise the SBL
> code except to modify the OPEN FILE statements to use PPCS. I only
> need to worry about code for calc fields on the SIMPOL side. (I have
> not found any virtual fields yet, mostly just concatonated keys.)
>
> For testing, this seems like a viable approach. I can wait to
> convert files until I am ready to archive the SBL code modules. Is
> this a good short-term and mid-term strategy? Are there any issues I
> am missing?
>
> Most importantly, can I still get Superbase PPCS 5 or 10 user
> licenses?

Hi Dan,

You are probably going to be better off switching to a SIMPOL-based PPCS
server. You can still use calcs, cons, and vals on the Superbase side,
by using the OPEN FILE USING syntax, although if you are using the SER()
function, you will need to switch to using a serial number table. The
SIMPOL server will be at least twice as fast as the Superbase one when
working with a Superbase client, and around 4 times faster using a
SIMPOL client.

We usually recommend switching the data back end as part of the initial
conversion.

Buying Superbase PPCS licenses is possible, but will cost you roughly
the same as a SIMPOL PPCS Server license.

Ciao, Neil

[Dan Jinks]

Thanks Neil,
I will test the SIMPOL PPCS server soon. I already have my primary SBL
code compatible with using PPCS, but thought I had much more rework to
do with the calc fields. If I can open them with OPEN FILE USING
syntax, it will be much easier to switch. I added my own serial number
function and table years ago, but must check it still functions properly
with the converted files.

-Dan

On 7/8/2011 6:46 AM, Neil Robinson wrote:
> On 07/07/2011 21:31, djinks wrote:
>> I set up a PPCS server using the SBL sample code and SBF files. I
>> opened one file in Simpol Personal and changes the field that is a
>> calculated field (last change field is a date-time calculation).
>> The change was accepted and shows as changed in the SBL programs.
>>
>> From this I infer that I can continue to use the current Superbase
>> files in a hybrid system via PPCS and do not need to revise the SBL
>> code except to modify the OPEN FILE statements to use PPCS. I only
>> need to worry about code for calc fields on the SIMPOL side. (I have
>> not found any virtual fields yet, mostly just concatonated keys.)
>>
>> For testing, this seems like a viable approach. I can wait to
>> convert files until I am ready to archive the SBL code modules. Is
>> this a good short-term and mid-term strategy? Are there any issues I
>> am missing?
>>
>> Most importantly, can I still get Superbase PPCS 5 or 10 user
>> licenses?
>
> Hi Dan,
>
> You are probably going to be better off switching to a SIMPOL-based PPCS
> server. You can still use calcs, cons, and vals on the Superbase side,
> by using the OPEN FILE USING syntax, although if you are using the SER()
> function, you will need to switch to using a serial number table. The
> SIMPOL server will be at least twice as fast as the Superbase one when
> working with a Superbase client, and around 4 times faster using a
> SIMPOL client.
>
> We usually recommend switching the data back end as part of the initial
> conversion.
>
> Buying Superbase PPCS licenses is possible, but will cost you roughly
> the same as a SIMPOL PPCS Server license.
>
> Ciao, Neil

[Dan Jinks]

I converted all files to smbe and used the SIMPOL PPCS server.
Everything works with my SBL code (modified with OPEN FILE USING) except
one file with a calc field on an index. Actually that file runs fine
except for a REQUEST 24 or 25 statement that I use to bring up a pick
list. I can even run quick reports against it with a filter. I decided
to just load that file exclusively from the local PC (no PPCS server/no
multi-user). It is used for lookups and is changed very in-frequently.
There is a change routine for the lookup file, but I will disable it.

I would be interested to know if I should be having this problem, as I
will still need to have calcs in indexes for the SBL code, although I
suppose I can find a work around and avoid REQUEST 26 on those files.
..
The error returned is 345, Invalid data received on remote connection
The behavior is that the app freezes. If I use the command line mode
(F1) from native Superbase, Superbase also freezes.

Here is my REQUEST statement:
REQUEST "Category Lookup","Pick a
category",24,Ans%,Cat$,70,indexLK.conxlook,description.conxlook
(notice I don't need to apply a WHERE or ORDER clause to the request to
cause the freeze)

Here is the file def:
IndexLK ;TXT IXD ;12 ;0 ;0 ;12 ;1 ;12 ;
Description ;TXT IXD ;30 ;1 ;0 ;30 ;1 ;30 ;
Button_Code ;TXT REQ IXD ;8 ;3 ;0 ;11 ;1 ;8 ;
Chart ;LOG ;1 ;4 ;0 ;5 ;1 ;1 ;
ButtonIndex ;TXT CLC RDO IXU ;21 ;5 ;0 ;21 ;1
;21 ;>
FRM PAD$ (Button_Code.CONXLOOK) + " " + IndexLK.CONXLOOK

Hope this is helpful.
-Dan

On 7/8/2011 6:46 AM, Neil Robinson wrote:
> On 07/07/2011 21:31, djinks wrote:
>> I set up a PPCS server using the SBL sample code and SBF files. I
>> opened one file in Simpol Personal and changes the field that is a
>> calculated field (last change field is a date-time calculation).he PPCS
>> The change was accepted and shows as changed in the SBL programs.
>>
>> From this I infer that I can continue to use the current Superbase
>> files in a hybrid system via PPCS and do not need to revise the SBL
>> code except to modify the OPEN FILE statements to use PPCS. I only
>> need to worry about code for calc fields on the SIMPOL side. (I have
>> not found any virtual fields yet, mostly just concatonated keys.)
>>
>> For testing, this seems like a viable approach. I can wait to
>> convert files until I am ready to archive the SBL code modules. Is
>> this a good short-term and mid-term strategy? Are there any issues I
>> am missing?
>>
>> Most importantly, can I still get Superbase PPCS 5 or 10 user
>> licenses?
>
> Hi Dan,
>
> You are probably going to be better off switching to a SIMPOL-based PPCS
> server. You can still use calcs, cons, and vals on the Superbase side,
> by using the OPEN FILE USING syntax, although if you are using the SER()
> function, you will need to switch to using a serial number table. The
> SIMPOL server will be at least twice as fast as the Superbase one when
> working with a Superbase client, and around 4 times faster using a
> SIMPOL client.
>
> We usually recommend switching the data back end as part of the initial
> conversion.
>
> Buying Superbase PPCS licenses is possible, but will cost you roughly
> the same as a SIMPOL PPCS Server license.
>
> Ciao, Neil

[Michael]

On 12/07/2011 16:49, djinks wrote:
> I converted all files to smbe and used the SIMPOL PPCS server.
> Everything works with my SBL code (modified with OPEN FILE USING)
> except one file with a calc field on an index. Actually that file
> runs fine except for a REQUEST 24 or 25 statement that I use to bring
> up a pick list. I can even run quick reports against it with a
> filter. I decided to just load that file exclusively from the local
> PC (no PPCS server/no multi-user). It is used for lookups and is
> changed very in-frequently. There is a change routine for the lookup
> file, but I will disable it.
>
> I would be interested to know if I should be having this problem, as
> I will still need to have calcs in indexes for the SBL code, although
> I suppose I can find a work around and avoid REQUEST 26 on those
> files. .. The error returned is 345, Invalid data received on remote
> connection The behavior is that the app freezes. If I use the
> command line mode (F1) from native Superbase, Superbase also
> freezes.
>
> Here is my REQUEST statement: REQUEST "Category Lookup","Pick a
> category",24,Ans%,Cat$,70,indexLK.conxlook,description.conxlook
> (notice I don't need to apply a WHERE or ORDER clause to the request
> to cause the freeze)
>
> Here is the file def: IndexLK ;TXT IXD ;12
> ;0 ;0 ;12 ;1 ;12 ; Description ;TXT IXD ;30
> ;1 ;0 ;30 ;1 ;30 ; Button_Code ;TXT REQ IXD ;8
> ;3 ;0 ;11 ;1 ;8 ; Chart ;LOG ;1
> ;4 ;0 ;5 ;1 ;1 ; ButtonIndex ;TXT CLC RDO IXU ;21
> ;5 ;0 ;21 ;1 ;21 ;> FRM PAD$ (Button_Code.CONXLOOK) + " " +
> IndexLK.CONXLOOK
>
> Hope this is helpful. -Dan

Hi Dan,

You may be mistaken in your assumption that it is related to the calc on
the index, since the calc is only performed when you save, not when you
read. More likely is that there is something problematic with the use of
the REQUEST 24 or 25 when working with PPCS. It may also be that you
simply need to adjust the txfactor and the retry and timeout values on
your connections. An error 345 implies that you have received bad data,
which could be line noise or some other problem in the network. Are you
doing this with only one machine? If so, use the IP address rather than
127.0.0.1, since the Microsoft loopback connector is pretty poor.

Ciao, Neil

> On 7/8/2011 6:46 AM, Neil Robinson wrote:
>> On 07/07/2011 21:31, djinks wrote:
>>> I set up a PPCS server using the SBL sample code and SBF files.
>>> I opened one file in Simpol Personal and changes the field that
>>> is a calculated field (last change field is a date-time
>>> calculation).he PPCS The change was accepted and shows as changed
>>> in the SBL programs.
>>>
>>> From this I infer that I can continue to use the current
>>> Superbase files in a hybrid system via PPCS and do not need to
>>> revise the SBL code except to modify the OPEN FILE statements to
>>> use PPCS. I only need to worry about code for calc fields on the
>>> SIMPOL side. (I have not found any virtual fields yet, mostly
>>> just concatonated keys.)
>>>
>>> For testing, this seems like a viable approach. I can wait to
>>> convert files until I am ready to archive the SBL code modules.
>>> Is this a good short-term and mid-term strategy? Are there any
>>> issues I am missing?
>>>
>>> Most importantly, can I still get Superbase PPCS 5 or 10 user
>>> licenses?
>>
>> Hi Dan,
>>
>> You are probably going to be better off switching to a SIMPOL-based
>> PPCS server. You can still use calcs, cons, and vals on the
>> Superbase side, by using the OPEN FILE USING syntax, although if
>> you are using the SER() function, you will need to switch to using
>> a serial number table. The SIMPOL server will be at least twice as
>> fast as the Superbase one when working with a Superbase client, and
>> around 4 times faster using a SIMPOL client.
>>
>> We usually recommend switching the data back end as part of the
>> initial conversion.
>>
>> Buying Superbase PPCS licenses is possible, but will cost you
>> roughly the same as a SIMPOL PPCS Server license.
>>
>> Ciao, Neil

[Dan Jinks]

Hello Neil,
I am using the proper IP. I have removed the calcs from the index and
reorganized the file then reconverted it to sbme and the reorganized it
again. I still freeze the SBL app if I try to use a REQUEST 24/25 on
it. I have other files are fine with the REQUEST 24/25. I'm not
spending more time on it as the statement works fine on a SBF file. I
don't need to manage change to that file centrally, so I'm moving on.
Once I get the SIMPOL form working, we can forget about it anyway.

I still need to do pick lists in SIMPOL, but it many cases i an use
dropdown combos. If that is not enough, what do you suggest I do to
replace the REQUEST 25? Perhaps a dialog with a list box or datagrid?

-Dan

On 7/13/2011 6:01 AM, Neil Robinson wrote:
> Hi Dan,
>
> You may be mistaken in your assumption that it is related to the calc on
> the index, since the calc is only performed when you save, not when you
> read. More likely is that there is something problematic with the use of
> the REQUEST 24 or 25 when working with PPCS. It may also be that you
> simply need to adjust the txfactor and the retry and timeout values on
> your connections. An error 345 implies that you have received bad data,
> which could be line noise or some other problem in the network. Are you
> doing this with only one machine? If so, use the IP address rather than
> 127.0.0.1, since the Microsoft loopback connector is pretty poor.
>
> Ciao, Neil

[Michael]

On 13/07/2011 16:49, djinks wrote:
> Hello Neil, I am using the proper IP. I have removed the calcs from
> the index and reorganized the file then reconverted it to sbme and
> the reorganized it again. I still freeze the SBL app if I try to use
> a REQUEST 24/25 on it. I have other files are fine with the REQUEST
> 24/25. I'm not spending more time on it as the statement works fine
> on a SBF file. I don't need to manage change to that file centrally,
> so I'm moving on. Once I get the SIMPOL form working, we can forget
> about it anyway.
>
> I still need to do pick lists in SIMPOL, but it many cases i an use
> dropdown combos. If that is not enough, what do you suggest I do to
> replace the REQUEST 25? Perhaps a dialog with a list box or
> datagrid?

Hi Dan,

In SIMPOL you will find the listpicker() function in the uisyshelp.sml
(the source is included as well). This is a drill down type of
functionality.

Ciao, Neil

[Dan Jinks]

Thanks Neil,
I'll look at listpicker today.

-Dan

On 7/14/2011 11:20 AM, Neil Robinson wrote:
> On 13/07/2011 16:49, djinks wrote:
>> Hello Neil, I am using the proper IP. I have removed the calcs from
>> the index and reorganized the file then reconverted it to sbme and
>> the reorganized it again. I still freeze the SBL app if I try to use
>> a REQUEST 24/25 on it. I have other files are fine with the REQUEST
>> 24/25. I'm not spending more time on it as the statement works fine
>> on a SBF file. I don't need to manage change to that file centrally,
>> so I'm moving on. Once I get the SIMPOL form working, we can forget
>> about it anyway.
>>
>> I still need to do pick lists in SIMPOL, but it many cases i an use
>> dropdown combos. If that is not enough, what do you suggest I do to
>> replace the REQUEST 25? Perhaps a dialog with a list box or
>> datagrid?
>
> Hi Dan,
>
> In SIMPOL you will find the listpicker() function in the uisyshelp.sml
> (the source is included as well). This is a drill down type of
> functionality.
>
> Ciao, Neil

[Dan Jinks]

I looked at the listpicker source, but do not have a good handle on it
yet. Looks like the listfiller function is something I must create and
pass into the listpicker function. Is there a working example that uses
the listpicker?
-Dan

On 7/14/2011 11:20 AM, Neil Robinson wrote:
> On 13/07/2011 16:49, djinks wrote:
>> Hello Neil, I am using the proper IP. I have removed the calcs from
>> the index and reorganized the file then reconverted it to sbme and
>> the reorganized it again. I still freeze the SBL app if I try to use
>> a REQUEST 24/25 on it. I have other files are fine with the REQUEST
>> 24/25. I'm not spending more time on it as the statement works fine
>> on a SBF file. I don't need to manage change to that file centrally,
>> so I'm moving on. Once I get the SIMPOL form working, we can forget
>> about it anyway.
>>
>> I still need to do pick lists in SIMPOL, but it many cases i an use
>> dropdown combos. If that is not enough, what do you suggest I do to
>> replace the REQUEST 25? Perhaps a dialog with a list box or
>> datagrid?
>
> Hi Dan,
>
> In SIMPOL you will find the listpicker() function in the uisyshelp.sml
> (the source is included as well). This is a drill down type of
> functionality.
>
> Ciao, Neil

[Author]

Posts