On Fri, 13 Mar 2015 08:17:26 +0800, Barry <smith.barryp at gmail.com> wrote:
>On 13 March 2015 at 01:21, Dinu Marina <dinumarina at gmail.com> wrote: > >> You should be also aware of a more common pitfall: unclosed result sets. >> Any lock is held until you read PAST the last row or you call stmt_finalize >> (or the equivalent abstraction in your DBAL). Always close select >> statements. > > >Hi Dinu, > >Am I correct in my understanding then that it is not enough to call >sqlite3_reset, I must call sqlite3_finalize after I am done with a >statement? sqlite3_reset() is enough to release the state/context of a statement. Aditionally, any BEGIN TRANSACTION should be paired with a COMMIT or ROLLBACK. >Cheers, > > - Barry -- Regards, Cordialement, Groet, Kees Nuyt
