Searched refs:TRIGGER (Results 1 – 16 of 16) sorted by relevance
16 # 1. CREATE and DROP TRIGGER tests20 # trig-1.4: DROP TRIGGER removes trigger38 CREATE TRIGGER trig UPDATE ON no_such_table BEGIN45 CREATE TEMP TRIGGER trig UPDATE ON no_such_table BEGIN55 CREATE TRIGGER tr1 INSERT ON t1 BEGIN61 CREATE TRIGGER tr1 DELETE ON t1 BEGIN70 CREATE TRIGGER tr2 INSERT ON t1 BEGIN73 CREATE TRIGGER tr2 INSERT ON t1 BEGIN80 DROP TRIGGER tr1;81 CREATE TRIGGER tr1 DELETE ON t1 BEGIN[all …]
83 CREATE TRIGGER xyz AFTER DELETE abc BEGIN UPDATE pqr;88 CREATE TRIGGER xyz AFTER DELETE abc BEGIN UPDATE pqr; END;93 CREATE TRIGGER xyz AFTER DELETE abc BEGIN100 CREATE TRIGGER xyz AFTER DELETE backend BEGIN106 CREATE TRIGGER xyz AFTER DELETE end BEGIN112 CREATE TRIGGER xyz AFTER DELETE end BEGIN119 CREATE TRIGGER xyz AFTER DELETE end BEGIN127 CREATE TRIGGER xyz AFTER DELETE [;end;] BEGIN133 CREATE TRIGGER xyz AFTER DELETE backend BEGIN140 TRIGGER xyz AFTER DELETE backend BEGIN[all …]
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 ROW128 CREATE TRIGGER delete_before_row BEFORE DELETE ON tbl FOR EACH ROW136 CREATE TRIGGER delete_after_row AFTER DELETE ON tbl FOR EACH ROW156 CREATE TRIGGER insert_before_row BEFORE INSERT ON tbl FOR EACH ROW164 CREATE TRIGGER insert_after_row AFTER INSERT ON tbl FOR EACH ROW291 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]\[all …]
24 CREATE TRIGGER before_tbl_insert BEFORE INSERT ON tbl BEGIN SELECT CASE 28 CREATE TRIGGER after_tbl_insert AFTER INSERT ON tbl BEGIN SELECT CASE 100 CREATE TRIGGER before_tbl_update BEFORE UPDATE ON tbl BEGIN104 CREATE TRIGGER before_tbl_delete BEFORE DELETE ON tbl BEGIN124 CREATE TRIGGER after_tbl2_insert AFTER INSERT ON tbl2 BEGIN140 CREATE TRIGGER tbl_view_insert INSTEAD OF INSERT ON tbl_view BEGIN
213 CREATE TRIGGER r1 AFTER UPDATE ON t2 FOR EACH ROW BEGIN422 CREATE TRIGGER t3r3 AFTER INSERT ON t3 BEGIN432 CREATE TRIGGER t3r3 AFTER INSERT ON t3 BEGIN489 CREATE TRIGGER r1 AFTER INSERT ON orig.t1 BEGIN;497 CREATE TRIGGER r5 AFTER INSERT ON t5 BEGIN504 DROP TRIGGER r5;505 CREATE TRIGGER r5 AFTER INSERT ON t5 BEGIN513 CREATE TRIGGER r5 AFTER INSERT ON t5 BEGIN520 CREATE TRIGGER r5 AFTER INSERT ON t5 BEGIN527 CREATE TRIGGER r5 AFTER INSERT ON t5 BEGIN[all …]
105 CREATE TRIGGER r1 AFTER INSERT ON t1 FOR EACH ROW BEGIN108 CREATE TRIGGER r2 AFTER DELETE ON t1 FOR EACH ROW BEGIN111 CREATE TRIGGER r3 AFTER INSERT ON t2 FOR EACH ROW BEGIN114 CREATE TRIGGER r4 AFTER DELETE ON t2 FOR EACH ROW BEGIN
851 CREATE TRIGGER r2 DELETE on t2 BEGIN870 CREATE TRIGGER r2 DELETE on t2 BEGIN887 CREATE TRIGGER r2 DELETE on t2 BEGIN906 CREATE TRIGGER r2 DELETE on t2 BEGIN924 CREATE TRIGGER r2 AFTER INSERT ON t2 BEGIN965 CREATE TRIGGER r1 DELETE on t1 BEGIN984 CREATE TRIGGER r1 DELETE on t1 BEGIN1001 CREATE TRIGGER r1 DELETE on t1 BEGIN1020 CREATE TRIGGER r1 DELETE on t1 BEGIN1037 CREATE TRIGGER r1 DELETE on t1 BEGIN[all …]
71 CREATE TRIGGER r1 AFTER DELETE ON t2 BEGIN
29 CREATE TRIGGER foo_insert BEFORE INSERT ON foo BEGIN
208 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
218 CREATE TRIGGER r1 AFTER DELETE ON t3 FOR EACH ROW BEGIN
266 CREATE TRIGGER r1 AFTER DELETE ON y1 FOR EACH ROW BEGIN
531 CREATE TEMP TRIGGER trigTest_1 AFTER UPDATE ON TempTable BEGIN
379 CREATE TRIGGER r3 AFTER INSERT on t3 FOR EACH ROW BEGIN
69 #define TRIGGER 0x33 macro
131 TEMP TRIGGER VACUUM VIEW.802 trigger_decl ::= temp(T) TRIGGER nm(B) trigger_time(C) trigger_event(D)882 cmd ::= DROP TRIGGER nm(X) dbnm(D). {