On 15 May 2012, at 8:17pm, Baruch Burstein <bmburst...@gmail.com> wrote:

> Which of the following should I be running right before calling
> sqlite3_close?
> 
> while(stmt = sqlite3_next_stmt(db, stmt))
>        sqlite3_finalize(stmt);

You would, of course, have to initialise your value for stmt before entering 
that loop.

> while(stmt = sqlite3_next_stmt(db, NULL))
>        sqlite3_finalize(stmt);
> 
> I am not sure which will have the desired effect.

I think that the second version makes a better clear-up routine.  I think that 
the first one would work too, but the second one looks more fault-tolerant.

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

Reply via email to