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', 'HY097')
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.
_______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
