*** 22,34 **** Here are other reasons for getting an SQLITE_LOCKED error: ! 1: Trying to CREATE or DROP a table or index while a SELECT statement is ! still pending. *:: Sometimes people think they have finished with a SELECT statement because sqlite3_step() has returned SQLITE_DONE. But the SELECT is not really complete until sqlite3_reset() or sqlite3_finalize() have been called. 2: Trying to write to a table while a SELECT is active on that same table. --- 22,36 ---- Here are other reasons for getting an SQLITE_LOCKED error: ! 1: Trying to CREATE or DROP a table or index while a SELECT statement is still pending. *:: Sometimes people think they have finished with a SELECT statement because sqlite3_step() has returned SQLITE_DONE. But the SELECT is not really complete until sqlite3_reset() or sqlite3_finalize() have been called. + + *:: As of check-in [3902] (2007-05-02 after version 3.3.17) this is + now allowed for CREATE statement. 2: Trying to write to a table while a SELECT is active on that same table.