If I do BEGIN EXCLUSIVE .... insert / update / delete queries here.... COMMIT
does it guarantee it will automatically rollback if the error occurs or do I have to specify it manually? What happens if I have 20 queries, 10 execute successfully (after COMMIT) and then it fails - will the database insert / update / delete first 10 or will it return to initial state before any inserts? Or do I have to use something like INSERT INTO [table] OR ROLLBACK... or something like that? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users