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

Reply via email to