On 4/12/19, Keith Medcalf <[email protected]> wrote: > > On Friday, 12 April, 2019 12:36, Richard Hipp <[email protected]> wrote: > >>Perhaps the SELECT is running inside of a transaction that was >>started >>before you did the INSERT. For example, perhaps you didn't >>sqlite3_finalize() the previous SELECT, which caused it to hold the >>read transaction open. > > Is it not sqlite3_reset that clears the transaction held by the VDBE code as > part of resetting the context back to the unexecuted state and that you do > not have to actually finalize (release) the statement
That is correct. I wrote hastily. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
