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

From A. Snelders
Subject Locate on Max() and Group By
Date
Msg-id 9miq6o$12el$1@news.tht.net
Whole thread Raw
Responses Re: Locate on Max() and Group By
List pgsql-general
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: "Ben Udkow"
Date:
Subject: ERROR: Function 'format_type(oid, int4)' does not exist
Next
From: ok@mochamail.com (Cody)
Date:
Subject: Re: SELECT FOR UPDATE