Locate on Max() and Group By
От
A. Snelders
Тема
Locate on Max() and Group By
Дата
Msg-id
9miq6o$12el$1@news.tht.net
Список
Дерево обсуждения
Re: Locate on Max() and Group By "A. Snelders" <asnelders@rem.nl>
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 по дате отправления