i'm caching the statements for later use, so i assume just doing reset is also ok? it seemed to work well.
Again thank you for help, wasted a few days on this. Thanks, Yuriy On Jun 25, 2013, at 6:49 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users