On 4 May 2013, at 6:43pm, Igor Korot <ikoro...@gmail.com> wrote: > If I start a transaction and there will be a failure for whatever reason, > do I have to call ROLLBACK? > Or this transaction will just stay somewhere in a journal and will not go > to db?
Reading from the end of <http://www.sqlite.org/lang_transaction.html> it looks like if anything fails you should be issuing a ROLLBACK. It may be required, and if it isn't required, it does no harm, though the ROLLBACK command itself will return another error which, presumably, you can always safely ignore. I would have thought that less confusing handling where any change error automatically triggered a ROLLBACK would have been better. Or perhaps where a ROLLBACK was always required but would not generate an error if it wasn't needed. There's a comment related to that in the final paragraph of that page. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
