On 25 Jun 2013, at 11:45pm, Yuriy Stelmakh <yuriy...@gmail.com> wrote:

> I assumed that commit would take care of sync, but because my
> statement was never finalized/reset after last use, it didn't it
> seems..

You always need to _finalize().  Getting the data you asked for is not the end 
of the job.  You have to _finalize() in order to let SQLite clear up after the 
statement (which does more than just unlock the file, it also does things about 
the memory your application uses).  So get used to this: for every _prepare() 
do a _finalize().  As soon as practical.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to