RE: DB test doesn't work in Komodo

2001-08-30 Thread Michael Robin
EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Andrew Malcolmson Sent: Thursday, August 30, 2001 4:18 PM To: [EMAIL PROTECTED] Subject: RE: DB test doesn't work in Komodo Hi, To answer your questions, yes, the script works at the command line. The only Python on my machine is ActivePython

RE: DB test doesn't work in Komodo

2001-08-30 Thread Andrew Malcolmson
Hi, To answer your questions, yes, the script works at the command line. The only Python on my machine is ActivePython 2.1.1. I have got it the script working in Komodo though. For some reason, if I execute a SELECT following the INSERT using the same cursor, the database is updated. If you hav

RE: DB test doesn't work in Komodo

2001-08-30 Thread Brian Quinlan
> 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