From: | <noreply(at)pgfoundry(dot)org> |
---|---|
To: | noreply(at)pgfoundry(dot)org |
Subject: | [ psqlodbc-Bugs-1000680 ] Problem with datatype when use selct id, sum(col) from table group by id |
Date: | 2006-07-03 18:24:02 |
Message-ID: | 20060703182402.8BB6086C5AA@pgfoundry.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | noreply | 2006-07-06 13:54:20 | [ psqlodbc-Bugs-1000681 ] Error when using ODBC driver with Microsoft Access |
Previous Message | noreply | 2006-07-03 10:55:56 | [ psqlodbc-Bugs-1000679 ] UNION select returns wrong column type with ADO (VB6) |