"Mike Johnston" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> I'm in a loop processing the result set using sqlite3_step. I need to
> insert/update the same sqlite database but a different table.  I
> can't get the write lock while I have this active statement I'm using
> sqlite3_step to move through.

With a recent enough SQLite version, you can run modification statements 
while a select statement is in progress. You have to do it on the same 
connection.

Igor Tandetnik



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

Reply via email to