On 23 Oct 2012, at 3:01am, YAN HONG YE <yanhong...@mpsa.com> 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
