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 по дате отправления
От: Ben Udkow
Дата:
От: ok@mochamail.com (Cody)
Дата:
Сообщение: Re: SELECT FOR UPDATE
FAQ