Hello,
I am pretty sure that at some point I have read if the following code
might bring me into trouble:
cur1 = conn.get_cursor()
cur2 = conn.get_cursor()
res = cur1.execute("SELECT id FROM data WHERE enabled == 1")
for name in res:
cur2.execute("UPDATE data SET enabled = 0 WHERE id=?", name)
So I am changing the result set over which I am iterating.
Unfortunately I can't find the document where I read about it - can
someone point me to the right resource?
Direct answers are of course also welcome :-)
Best,
-Nikolaus
--
»Time flies like an arrow, fruit flies like a Banana.«
PGP fingerprint: 5B93 61F8 4EA2 E279 ABF6 02CF A9AD B7F8 AE4E 425C
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
