updates in sqlite3 do not work

Stefan Sonnenberg-Carstens stefan.sonnenberg at pythonmeister.com
Tue May 29 18:43:58 EDT 2007


Did you try a commit() ?

SQLite3 works in autocommit mode by default,
so it would help to see your code.


On Mi, 30.05.2007, 00:30, Chris Fonnesbeck wrote:
> I have a script set up to perform UPDATE commands on an sqlite database
> using the sqlite3 module. Everything appears to run fine (there are no
> error
> messages), except that none of the UPDATE commands appear to have actually
> updated the table. If I run each command on its own in a sqlite session,
> the
> UPDATE command works fine, so it is not a SQL syntax issue. UPDATE simply
> seems not to work. Any idea what the problem might be?
>
> Thanks,
> Chris
> --
> http://mail.python.org/mailman/listinfo/python-list




More information about the Python-list mailing list