On 5 Mar 2017, at 3:06pm, Yuri <y...@rawbw.com> wrote: > On 03/05/2017 03:48, Keith Medcalf wrote: >> Perhaps because you are committing the transaction? > > There is no COMMIT statement there.
If you try to execute a command without putting it in a transaction (i.e. using BEGIN) then SQLite wraps it in a transaction of its own. So a command like UPDATE … is processed as if it is BEGIN UPDATE … COMMIT If you want to delay the ending of the transaction you have to put the BEGIN in before it, and then you must put the COMMIT in after it or it won’t be committed. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users