Vivien Malerba <vmale...@gmail.com> wrote: > I have the following situation: > * a prepared statement (for a SELECT) on which sqlite3_step has been > called successfully (meaning having returned SQLITE_ROW or > SQLITE_DONE each time) > * I call sqlite3_reset() on it > * I start using sqlite3_step again on it > > The question is: will the rows I read on the 2nd pass be the same as > the ones I've read on the 1st pass, or will the statement be executed > again (and may be different if the database has changed in the > meanwhile)?
The latter. If you need to make sure the data doesn't change between the two passes, run them in an explicit transaction. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users