Aggregate function problem in VB6

From: "Sekcja Informatyki Medycznej" <informatyka(at)cskmswia(dot)pl>
To: "pgsql-odbc" <pgsql-odbc(at)postgresql(dot)org>
Subject: Aggregate function problem in VB6
Date: 2001-05-31 15:10:18
Message-ID: 001f01c0e9e3$ce884920$9100000a@szpital.cskmswia.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Tom Lane 2001-05-31 16:38:19 Re: Aggregate function problem in VB6
Previous Message Hafsteinn Þór Hafsteinsson 2001-05-31 11:53:35 Dynaset