Actually, sqlite3_reset() does release the lock on the database. What made you think differently?
Pavel On Fri, Mar 12, 2010 at 3:17 PM, TeDe <[email protected]> wrote: > Hello Folks, > > I'm looking for a way to close a statement, but do not want to finalize > it. I have 2 statement I would like to execute in a loop. Since I want > to reuse them, I do not want to finalize them. Unfortunately > sqlite3_reset() does not release the lock on the database. So I need a > function that does something between finalize() and reset(). > > Here is some pseudo code. > > prepare(stmt1); > prepare(stmt2); > > for(int i = 0; i < anzahl; i++){ > bind_value(stmt1); > step(stmt1); > close(stmt1); > > bind_value(stmt2); > step(stmt2); > close(stmt2); > } > > finalize(stmt1); > finalize(stmt2); > > Can somebody help me with this? Is there such a function? Or do I have > to open 2 separate connections (in the same thread)? > > Best regards, > > Thomas > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
