On 23 Oct 2012, at 3:01am, YAN HONG YE <[email protected]> wrote: > 3. prepare and step stmt A (SELECT * FROM foo WHERE rowid=1), A is not > finalized or reset; > 4. execute stmt B (DELETE FROM foo WHERE rowid=1), B is prepared, executed > and finalized; > 5. access column data via stmt A
You cannot depend on this working. Do not write your software like that. Finalize your SELECT before you execute your DELETE statements. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
