"CARTER-HITCHIN, David, FM" <[EMAIL PROTECTED]> wrote: > Hi Richard, > > > You should be in the habit of calling sqlite3_reset() on each query > > as soon as that query finishes. Otherwise the query *might* leave a > > read-lock on the database file and thus prevent subsequent write > > operations for working correctly. > > What about if one just uses sqlite3_exec ? The manual says that > sqlite3_reset > is only needed for SQL that was prepared. >
sqlite3_exec calls sqlite3_reset and sqlite3_finalize automatically. -- D. Richard Hipp <[EMAIL PROTECTED]>
