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: > > 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. Update the value of d > 4. The value of d has now been but the entire module within the step > module is being re-run. > > I have been able to get around this by calling sqlite3_clear_bindings and > sqlite3_reset within the step. > > -- View this message in context: http://old.nabble.com/sqlite3_step-to-select-and-update-the-same-table-tp30152284p30157406.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
