Hi, On Wed, Oct 4, 2017 at 6:19 PM, J. King <jk...@jkingweb.ca> wrote: > See also: > <http://sqlite.org/lang_conflict.html>
This is good to know but I don't think it is applicable in this case as I explicitly said that this is inside transaction which fails. Thank you. > > On October 4, 2017 6:15:55 PM EDT, Jens Alfke <j...@mooseyard.com> wrote: >> >> >>> On Oct 4, 2017, at 2:20 PM, Igor Korot <ikoro...@gmail.com> wrote: >>> >>> If I start transaction, all queries were successful, but issuing >>"COMMIT" fails. >>> On such failure I am going to present an error, but then what happens >>> if I go and try to close the connection? >> >>If COMMIT fails, you should execute a ROLLBACK to abort the >>transaction, then continue with failure handling. Otherwise yes, the >>transaction remains open and will cause trouble when you try to close >>the connection. >> >>—Jens >> >>_______________________________________________ >>sqlite-users mailing list >>sqlite-users@mailinglists.sqlite.org >>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > -- > Sent from my Android device with K-9 Mail. Please excuse my brevity. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users