[ psqlodbc-Bugs-1000680 ] Problem with datatype when use selct id,sum(col) from table group by id

Bugs item #1000680, was opened at 2006-07-03 18:24
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10006 80&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: Problem with datatype when use selct id,sum(col) from table group by id

Initial Comment:
Hello,
i use PostGresSql 8.1.4 on Windows or 8.0.3 on Linux and ODBC 8.2.2 with ADI in Visual Basic 6 on Windows XP in German environment. The Dezimale is the komma(,).

My result on the sum function differs on the checkValue ParseStatements in the ODBC.
Is it checked, i have the wrong result like:
74, sum = 110652.6 DefinedSize:8 NumericScale:255 Precision:255 Type:202 ActualSize:16
In the sum is a dot and that means later that it will be 1106526.

Is it not checked it is OK
74: sum = 110652,66 DefinedSize:8 NumericScale:255 Precision:15 Type:5 ActualSize:8

I must have Parse Statement checked.
When it is unchecked i get an error with ado.recordset.update with in german:
"Nicht genügend Basistabelleninformationen vorhanden"


As attachment a logfile from odbc.
My look shows per example two lines with errormessages:

-----
---------------- Socket Info -------------------------------
socket=1144, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=211650832, buffer_out=211643472
buffer_filled_in=76, buffer_filled_out=0, buffer_read_in=76
CONN ERROR: func=PGAPI_NativeSql, desc='', errnum=215, errmsg='The buffer was too small for the NativeSQL.'
------------------------------------------------------------
henv=cbcb4e0, conn=cc0cab8, status=1, num_stmts=16
sock=cbc10f8, stmts=cbf1708, lobj_type=-999
---------------- Socket Info -------------------------------
socket=1144, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=211650832, buffer_out=211643472
buffer_filled_in=76, buffer_filled_out=0, buffer_read_in=76
STATEMENT ERROR: func=PGAPI_ColAttributes, desc='', errnum=1, errmsg='Can't get column attributes: no result found.'
------


Is there a fix to my Problems with the Numbers and/or the ado.recs.update ?


Thanks
Paul

------------------------------------------------------------ ----------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10006 80&group_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match