Hello, just a short question:
With the current sqlite version, is it possible to have nested transactions, e.g. exec select ... from table while (fetch row) { if (criteria) exec delete from t where ... } which means execute some 'select', fetching the results in a loop and inside the loop executing e.g. 'delete' statements on the same table based on the data returned by the fetch? The 'definitive guide to sqlite' book that I have (which is based on an now outdated version of sqlite) says it isn't and I have to put the results of the select into another temporary table or local storage to work around the problem, but I thought I had heard about new support for nested transactions. Thanks for any insight. Regards Guido _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users