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

On Wed, 29 Aug 2001, A. Snelders wrote:

> 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

Is 'Hallo' the maximum value for the group its in?  You may
want to turn up debugging to level 2 (I think that's the level)
so the queries sent get written to the log to see what's being
sent when you do the Locate().