Lines Matching refs:TRIGGER
85 CREATE TRIGGER before_update_row BEFORE UPDATE ON tbl FOR EACH ROW
93 CREATE TRIGGER after_update_row AFTER UPDATE ON tbl FOR EACH ROW
101 CREATE TRIGGER conditional_update_row AFTER UPDATE ON tbl FOR EACH ROW
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
156 CREATE TRIGGER insert_before_row BEFORE INSERT ON tbl FOR EACH ROW
164 CREATE TRIGGER insert_after_row AFTER INSERT ON tbl FOR EACH ROW
291 execsql "CREATE TRIGGER the_trigger BEFORE [string range $statement 0 6]\
296 execsql "DROP TRIGGER the_trigger;"
303 execsql "CREATE TRIGGER the_trigger AFTER [string range $statement 0 6]\
307 execsql "DROP TRIGGER the_trigger;"
331 CREATE TRIGGER tbl_after_update_cd BEFORE UPDATE OF c, d ON tbl
362 execsql "CREATE TRIGGER $trig BEGIN UPDATE log set a = a + 1; END;"
397 CREATE TRIGGER tr1 BEFORE INSERT ON tblA BEGIN
401 CREATE TRIGGER tr2 BEFORE INSERT ON tblB BEGIN
422 CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl
440 CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl
462 CREATE TRIGGER ai_tbl AFTER INSERT ON tbl BEGIN
516 CREATE TRIGGER au_tbl AFTER UPDATE ON tbl BEGIN
587 CREATE TRIGGER before_update INSTEAD OF UPDATE ON abcd BEGIN
591 CREATE TRIGGER after_update INSTEAD OF UPDATE ON abcd BEGIN
596 CREATE TRIGGER before_delete INSTEAD OF DELETE ON abcd BEGIN
600 CREATE TRIGGER after_delete INSTEAD OF DELETE ON abcd BEGIN
605 CREATE TRIGGER before_insert INSTEAD OF INSERT ON abcd BEGIN
609 CREATE TRIGGER after_insert INSTEAD OF INSERT ON abcd BEGIN
675 CREATE TRIGGER r1 INSTEAD OF DELETE ON v1 BEGIN
698 CREATE TRIGGER r2 INSTEAD OF INSERT ON v1 BEGIN
708 CREATE TRIGGER r3 INSTEAD OF UPDATE ON v1 BEGIN