> Marcus Grimm <mgr...@medcom-online.de> wrote: >> I'm a bit confused about Igors replies because >> you can very well do a select, step throu the >> results and even delete or update the table row that you >> are currently inspecting and procceed with stepping. > > ... but you cannot COMMIT your changes while still stepping through the > select. This is the crux of the OP's problem.
ahh, okay..yes. I missed that this is the intension of the OP: to start a transaction outside the select loop and COMMIT sometime inside and procced with stepping. what is possible I guess would be to start a transaction inside the loop, do something, and commit and procced with stepping (actually sqlite does this anyhow internally). I'm still curious what would be the error code of sqlite3_step if I would delete a row that would be one of the rows reached by the running statement, but that's another issue...;) Best Marcus > > Igor Tandetnik > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
