Marcus Grimm <mgr...@medcom-online.de> wrote: >> Marcus Grimm <mgr...@medcom-online.de> wrote: >>> what is possible I guess would be to start a transaction >>> inside the loop, do something, and commit and procced >>> with stepping >> >> No, this is not possible either. By starting the select, you also >> start an implicit transaction. SQLite doesn't support nested >> transactions, so you can't start another one in the middle of the >> loop. > > hm... just read again some docs... you are right I guess, > as usual... but reading the docs > (http://www.sqlite.org/lang_transaction.html): > "..The explicit COMMIT command runs immediately, even if there are > pending SELECT statements..."
Hmm. This must be something new. I don't remember seeing this before, and I'm pretty sure that, with SQLite version I use (3.5.*, don't remember exactly), COMMIT fails if there's a SELECT statement that's not reset nor finalized. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users