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