Paradox Community

Items in pnews.paradox-client_server

Subject:Re: Postgresql indexes issue with lower function
Date:Thu, 12 Mar 2020 09:32:41 -0500
From:Mark Bannister <markRemove@THISinjection-moldings.com>
Newsgroups:pnews.paradox-client_server
I see that and agree but two questions:
1.) I copy the PG results to PRIV.  But to display in a form it would be
easier if I had indexes on the PRIV tables, or I just do sub-query for
the children separately I guess?

2.) I was trying to get to a hybrid stage quickly so that if Microsoft
forces me off SMB1 I have a viable option.  It's going to take a lot of
work to move all the logic to PG and I'm afraid I will run out of time.
 This also gives me a chance to learn as I go and work on small chunks
at a time.

3.) OK I lied about the number of questions.  Do you suggest using
tcursors on PG server tables at all?  They seem to work just fine.

Thanks so much for your help.

On 3/11/2020 8:26 PM, Tom Krieg wrote:
> Another reason to always keep all the database processing and retrieving
> logic on the PG server. Rather than link to a PG table in your form, do
> a pass-through PG SELECT .... FROM <table> and link to the result table.
> 
> You're going to spend a lot of unfruitful time trying to get direct
> linking working and when you finally separate Paradox and Postgres with
> pass-through SQL that time will have been wasted. Grit your teeth and
> separate the two now. You'll be glad you did. Performance for one.
> 
> On 12/03/2020 10:21 am, Mark Bannister wrote:
>> It looks likes pdox cannot use an index that has uses the lower function
>> in it.  You get a "number out of range" error and if you look at the
>> table in the filter dialog the index field names are missing on those
>> fields.
>>
>> -- 
>> Mark B
>>
> 


Copyright © 2004 thedbcommunity.com