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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
