Hi, On Wed, Oct 4, 2017 at 6:19 PM, J. King <[email protected]> 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 <[email protected]> wrote: >> >> >>> On Oct 4, 2017, at 2:20 PM, Igor Korot <[email protected]> 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 >>[email protected] >>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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
