| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | "A(dot) Snelders" <asnelders(at)rem(dot)nl> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Locate on Max() and Group By |
| Date: | 2001-08-31 14:36:24 |
| Message-ID: | Pine.BSF.4.21.0108310734410.58756-100000@megazone23.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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().
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alex Pilosov | 2001-08-31 14:45:22 | Re: Deployment of PostgreSQL Applications |
| Previous Message | Giuseppe Tanzilli - CSF | 2001-08-31 14:27:05 | Re: Apache authentication |