When I run the simple (Access XP via ODBC) database test script below,
interactively and in PythonWin it works but in Komodo 1.1 it doesn't. A
'1' result is returned but the row isn't inserted.
import dbi, odbc
sqlInsert = "INSERT INTO table_name(field_name) VALUES ('blah')"
myconn = odbc.odbc('DSN_Name')
cursor = myconn.cursor()
cursor.execute(sqlInsert)
myconn.commit()
cursor.close()
myconn.close()
Any ideas?
_______________________________________________
ActivePython mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/activepython
