Odp: Aggregate function problem in VB6

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@tpf.co.jp>
To: Sekcja Informatyki Medycznej <informatyka@cskmswia.pl>
Cc: pgsql-odbc <pgsql-odbc@postgresql.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
>