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

Odp: Aggregate function problem in VB6

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


In response to

Responses

pgsql-odbc by date

Next:From: mazzo's accountDate: 2001-06-01 17:55:24
Subject: which odbc driver from ftp
Previous:From: Hiroshi InoueDate: 2001-06-01 02:16:04
Subject: Re: Aggregate function problem in VB6

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