I'm running the 3.5.7 version now. My understanding was that if I have a prepared statement and currently using sqlite_step to walk through the results, the database was unable to commit a write. In my case, I would be using the same connection. Would you explain more? Also, what if same connection but different thread (assuming sqlite compiled with multi-thread option turned on).
Many thanks Igor Tandetnik <[EMAIL PROTECTED]> wrote: "Mike Johnston" 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 --------------------------------- Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
