Re: [sqlite] EXTERNAL: sqlite3_step to select and update the same table

I thought call to clear bindings and reset was working but I got confused and am wherever I was before posting on the forum. Still have no conclusive evidence as to why the database in my application is behaving in a weird fashion. Any further input would be appreciated. cricketfan wrote: > >

Re: [sqlite] EXTERNAL: sqlite3_step to select and update the same table

Mike I also was not able to reproduce this behavior with a small sample program and am puzzled by this behavior in my main application. What puzzled me is 1. Select has criteria a=?, b=?, c=? (prepare statement) - step through it 2. Get the value of d from database based on the above criteria 3.

Re: [sqlite] EXTERNAL: sqlite3_step to select and update the same table

I think the quick answer is to use a different database handle for your update. I think you may also be able to do this with WAL mode. http://www.sqlite.org/draft/wal.html I did some searching and couldn't find a definitive answer for doing an update inside a select loop (though I'm sure I've