Lines Matching refs:DELETE

20 # trigger2-1.2.*: DELETE trigger execution model.
25 # trigger program can correctly execute INSERT, UPDATE, DELETE * SELECT
124     DELETE FROM rlog;
125     DELETE FROM tbl;
128     CREATE TRIGGER delete_before_row BEFORE DELETE ON tbl FOR EACH ROW
136     CREATE TRIGGER delete_after_row AFTER DELETE ON tbl FOR EACH ROW
146       DELETE FROM tbl;
155     DELETE FROM rlog;
205   {DELETE FROM log WHERE a = 1;}
208     DELETE FROM log;}
223       set statement {DELETE FROM tbl WHERE a = 1;}
252     if {$statement_type == "DELETE"} {
290     execsql "DELETE FROM tbl; DELETE FROM log; $prep";
297     execsql "DELETE FROM tbl; DELETE FROM log;"
302     execsql "DELETE FROM tbl; DELETE FROM log; $prep";
445       DELETE FROM tbl WHERE a = 1;
446       DELETE FROM tbl;
509 execsql {DELETE FROM tbl}
596   CREATE TRIGGER before_delete INSTEAD OF DELETE ON abcd BEGIN
600   CREATE TRIGGER after_delete INSTEAD OF DELETE ON abcd BEGIN
619     DELETE FROM abcd WHERE a = 1;
632     DELETE FROM tlog;
635     DELETE FROM abcd WHERE a = 1;
648     DELETE FROM tlog;
649     DELETE FROM abcd WHERE a = 1;
675     CREATE TRIGGER r1 INSTEAD OF DELETE ON v1 BEGIN
678     DELETE FROM v1 WHERE x=1;
684     DELETE FROM v1 WHERE x=3;
691     DELETE FROM v1log;
692     DELETE FROM v1 WHERE y=11;
701     DELETE FROM v1log;
711     DELETE FROM v1log;