On Wed, Mar 09, 2011 at 02:01:14AM -0800, pkcpkc scratched on the wall: > > What would happen if the following situation occurs: > I begin a transaction and then do multiple sqlite execute statements. One of > the execute statements fails and I try doing a rollback. Now when I try the > rollback the rollback also fails. Does it mean database is corrupted? > Or will it be rolled back automatically?
There are situations when a statement error can cause a rollback. It is possible SQLite automatically rolled back the transaction on the first error. This would cause the ROLLBACK to return an error. What is the error code returned by the ROLLBACK? -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
