----- Original message ----- > I am using the sqlite3 module with Python 3.1, and have some code which > goes something like as follows... > > import sqlite3 > con = sqlite3.connect('MyDatabase.db') > > try: > execresult = con.execute('INSERT INTO MyTable (field_name) VALUES > ("MyValue")') > con.commit() > except:
Here you catch all exceptions. Normally you would catch a specific exception like ValueError. > con.rollback() > Do you know finally? It is run after all the exceptions have been handled and this is where I would put the rollback. Greets, Sander _______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: http://mail.python.org/mailman/listinfo/tutor