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