Re: Locate on Max() and Group By - Mailing list pgsql-general

From A. Snelders
Subject Re: Locate on Max() and Group By
Date
Msg-id 9mlgnd$1lhr$1@news.tht.net
Whole thread Raw
In response to Locate on Max() and Group By  ("A. Snelders" <asnelders@rem.nl>)
List pgsql-general
I have found the answer:
In my ODBC-Driver by Driver, Optie Text as LongVarChar, this must be False
(I had True)
Now it works.

"A. Snelders" <asnelders@rem.nl> wrote in message
news:9miq6o$12el$1@news.tht.net...
> I have the next problem:
>
> I open an table with
>
> select dnkey, Max(dvnaam) as dvnaam2, Max(dvpersoonnr) as dvpersoonnr
from
> tbmedewerker
> group by dnkey
>
> When I want to locate like
>
>     TblTbPGSMedew.Locate( 'dvnaam2', 'Hallo', [ ]);
>
> then 'Hallo' isn't find
>
> but when I open the table without Max() en group By like
>
> select dnkey, dvnaam as dvnaam2   from tbmedewerker
>
> then 'Hallo' is find.
>
> How can I fixed this problem?
> I working with PostgreSQL 7.1 and Delphi 5
>
>
>



pgsql-general by date:

Previous
From: "Corn"
Date:
Subject: What's wrong about this sql statement?
Next
From: "Alex Knight"
Date:
Subject: Re: speed of communication and pgsql development