I need a function to run step 2 in sql cmd, but I don't know how to write in the sql environment.
1. BEGIN TRANSACTION; 2. if today is mondy to fridy,then run 3-6 ELSE run 6. 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 6. COMMIT _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users