Thanks, all working beautifully now. RBS
On Fri, Mar 20, 2015 at 1:27 AM, Simon Slavin <slavins at bigfraud.org> wrote: > > On 19 Mar 2015, at 11:48pm, Bart Smissaert <bart.smissaert at gmail.com> > wrote: > > > Is this all how it should be? > > Apart from the following, nothing I see looks like it will cause > problems. You should be checking the result codes of all the calls you do > to make sure you are getting SQLITE_OK (==0) returned from them and not an > error. > > > Where/when should I call sqlite3_close? > > Once you know you don't need access to the database any more. Before your > application quits. As above, check to see that you are getting SQLITE_OK > back to indicate that your connection to the database was still working > correctly when you closed it. > > > Does Clearbindings come indeed before finalize? > > You do not need to clear bindings before _finalize(), since _finalize() > releases all the bindings for you as part of releasing all resources used > by the statement. > > You might want to clear bindings before or after a _reset(), since it can > help you to find errors when you start binding for the next use of the > statement. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >