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