[DB-SIG] pyodbc and decimal datatypes
ccurvey at gmail.com
Fri Mar 31 18:08:28 CEST 2006
I hope I have the right list for this question...
According to the homepage for pyodbc, pyodbc supports decimal data types,
but when I try to copy a row from one table to another, I'm getting:
pyodbc.NotSupportedError: ('Python type Decimal not supported. param=26',
the code looks like:
srcCursor.execute("select * from foo")
for row in srcCursor:
targetCursor.execute("insert into bar ( ?, ?, ?, ....", row)
(Where bar is an empty copy of foo).
Using pyodbc 2.0.16 with python 2.4.1 on Windows XP
Nervous passengers are advised to wear a blindfold.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the DB-SIG