sqlite3_exec doesn't open transaction by itself. Each statement is prepared and executed separately.
2018-05-30 15:33 GMT+02:00, Simon Slavin <slav...@bigfraud.org>: > On 30 May 2018, at 2:30pm, Simon Slavin <slav...@bigfraud.org> wrote: > >> Does SQLite perform the whole _exec() in one transaction or each command >> in a separate transaction ? > > Subsidiary question: > > Does SQLite parse the entire string of commands for a syntax error first, > triggering an error if anything is wrong before executing the first command > ? Or does it execute the first command, then parse the next part of the > string for a command ? > > Simon. > _______________________________________________ > 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