Hi, I have multiple processes using a single database for both read and write. I want to ensure that my interpretation of the v3 API spec is correct. In particular, I want to ensure that all processes lock the database for the minimum time possible and release the lock as soon as they have finished processing the SQL statement. Are locks released automatically on error/done, or manually by the sqlite3_reset() call, or some other function?
I currently use the following logic in my internal DB layer. if sql not prepared sqlite3_prepare_v2() sqlite3_bind_* ... rc = sqlite3_step() while rc == SQLITE_ROW process row (sqlite3_column_*) ... rc = sqlite3_step() if rc != SQLITE_DONE process error sqlite3_reset() Will this release the locks on the database (assuming no transactions?) by the end of the function? Regards, Brodie ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------