Aggregate function problem in VB6 - Mailing list pgsql-odbc

From Sekcja Informatyki Medycznej
Subject Aggregate function problem in VB6
Date
Msg-id 001f01c0e9e3$ce884920$9100000a@szpital.cskmswia.pl
Whole thread Raw
Responses Re: Aggregate function problem in VB6
List pgsql-odbc
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.

I use:
    PostgreSQL 7.1 on OpenBSD 2.9
    ODBC PostgreSQL 7.01.0005
    MS Visual Studio 6.0 SP 5
    MS ActiveX Data Objects 2.6 Library
    Microsoft OLE DB Provider for ODBC Driver

Other aggregate functions work ok.

Thanks
    Przemek Wieclawek.


pgsql-odbc by date:

Previous
From: Hafsteinn Þór Hafsteinsson
Date:
Subject: Dynaset
Next
From: Tom Lane
Date:
Subject: Re: Aggregate function problem in VB6