Locate on Max() and Group By

From: "A(dot) Snelders" <asnelders(at)rem(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: Locate on Max() and Group By
Date: 2001-08-29 13:20:18
Message-ID: 9miq6o$12el$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2001-08-29 13:25:34 Re: How do I pack a class into a string? Is serialize available?
Previous Message Jacob Vennervald Madsen 2001-08-29 13:16:36 Default encoding in database