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
Список 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 по дате отправления: