From: | "Sekcja Informatyki Medycznej" <informatyka(at)cskmswia(dot)pl> |
---|---|
To: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
Cc: | "pgsql-odbc" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Odp: Aggregate function problem in VB6 |
Date: | 2001-06-01 14:00:29 |
Message-ID: | 000f01c0eaa3$39106b00$9100000a@szpital.cskmswia.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi,
This is Postgres logfile:
DEBUG: StartTransactionCommand
DEBUG: query: SELECT SUM(field) FROM table
DEBUG: ProcessQuery
DEBUG: CommitTransactionCommand
Log seems ok to me but still SUM() doesn't work on VB side.
Regards,
Przemek Wieclawek
----- Original Message -----
From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Sekcja Informatyki Medycznej <informatyka(at)cskmswia(dot)pl>
Cc: pgsql-odbc <pgsql-odbc(at)postgresql(dot)org>
Sent: Friday, June 01, 2001 4:16 AM
Subject: Re: [ODBC] Aggregate function problem in VB6
> Sekcja Informatyki Medycznej wrote:
> >
> > Hi,
> > I have encountered a problem with following query run over ODBC in MS VS
6.0
> > SP5 in DataEnvironment designer:
> >
> > "SELECT SUM(field1) FROM table1;"
> > field 1 is of type INT4.
> >
> > There is "E_FAIL" error message.
> >
>
> Could you see the server-side log ?
> Try running the postmaster with -d2 (and without -S)
> and see what gets logged in its stderr output.
>
> regards,
> Hiroshi Inoue
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
From | Date | Subject | |
---|---|---|---|
Next Message | mazzo's account | 2001-06-01 17:55:24 | which odbc driver from ftp |
Previous Message | Hiroshi Inoue | 2001-06-01 02:16:04 | Re: Aggregate function problem in VB6 |