Thread: [ psqlodbc-Bugs-1000680 ] Problem with datatype when use selct id,sum(col) from table group by id
[ psqlodbc-Bugs-1000680 ] Problem with datatype when use selct id,sum(col) from table group by id
From
Date:
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=1000680&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=1000680&group_id=1000125