On Tue, May 6, 2014 at 2:31 PM, Jim Carroll <[email protected]> wrote: > > CREATE TABLE A(id INT PRIMARY KEY, val TEXT); > INSERT INTO A VALUES(1, "hello"); > BEGIN; > DELETE FROM A; > INSERT INTO A VALUES(1, "goodbye"); > INSERT INTO A VALUES(1, "world"); > COMMIT;
Sounds like you want ON CONFLICT ROLLBACK. --DD http://www.sqlite.org/lang_conflict.html _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
