Re: [sqlite] Sqlite3_reset needed?

2006-03-23 Thread drh
"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 > > operation

RE: [sqlite] Sqlite3_reset needed?

2006-03-23 Thread CARTER-HITCHIN, David, FM
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

Re: [sqlite] Sqlite3_reset needed?

2006-03-23 Thread drh
"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 t

RE: [sqlite] Sqlite3_reset needed?

2006-03-23 Thread Merijn Vandenabeele
Correct. Thanks for your help! Merijn -Oorspronkelijk bericht- Van: Martin Engelschalk [mailto:[EMAIL PROTECTED] Verzonden: donderdag 23 maart 2006 12:13 Aan: sqlite-users@sqlite.org Onderwerp: Re: [sqlite] Sqlite3_reset needed? Hi, if i understand you right, the bound variables

Re: [sqlite] Sqlite3_reset needed?

2006-03-23 Thread Martin Engelschalk
Hi, if i understand you right, the bound variables occur in your where class. If you want to start stepping through your result set with newly bound variables, you have to reset the statement first. You can also reset the statement, put new values into the already bound variables and start step