"Merijn Vandenabeele" <[EMAIL PROTECTED]> wrote: > Hi, > > I prepare a statement in my constructor's class. Later, when I need data > from that statement, I bind all variables and step trough the results. Is it > necessary to reset the statement when I need other data from that statement > or is this done automatically when I bind new variables? >
Yes. sqlite3_reset() is always required to restart a query. 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. -- D. Richard Hipp <[EMAIL PROTECTED]>
