Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group