Paradox Community

Items in pnews.paradox-client_server

Subject:Re: Postgresql indexes issue with lower function
Date:Thu, 12 Mar 2020 12:26:40 +1100
From:Tom Krieg <REMOVEtomkCAPITALS@sdassociates.com.au>
Newsgroups:pnews.paradox-client_server
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