Lines Matching refs:TRIGGER

98       CREATE TRIGGER before_update_row BEFORE UPDATE ON tbl FOR EACH ROW 
107       CREATE TRIGGER after_update_row AFTER UPDATE ON tbl FOR EACH ROW 
116       CREATE TRIGGER conditional_update_row AFTER UPDATE ON tbl FOR EACH ROW
148       CREATE TRIGGER delete_before_row BEFORE DELETE ON tbl FOR EACH ROW
157       CREATE TRIGGER delete_after_row AFTER DELETE ON tbl FOR EACH ROW
182       CREATE TRIGGER insert_before_row BEFORE INSERT ON tbl FOR EACH ROW
191       CREATE TRIGGER insert_after_row AFTER INSERT ON tbl FOR EACH ROW
316     execsql "CREATE TRIGGER the_trigger BEFORE [string range $statement 0 6]\
321     execsql "DROP TRIGGER the_trigger;"
328     execsql "CREATE TRIGGER the_trigger AFTER [string range $statement 0 6]\
332     execsql "DROP TRIGGER the_trigger;"
351   CREATE TRIGGER tbl_after_update_cd BEFORE UPDATE OF c, d ON tbl
384   execsql "CREATE TRIGGER $trig BEGIN UPDATE log set a = a + 1; END;"
420   CREATE TRIGGER tr1 BEFORE INSERT ON tblA BEGIN
424   CREATE TRIGGER tr2 BEFORE INSERT ON tblB BEGIN
445   CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl 
463   CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl 
486     CREATE TRIGGER ai_tbl AFTER INSERT ON tbl BEGIN
540     CREATE TRIGGER au_tbl AFTER UPDATE ON tbl BEGIN
614   CREATE TRIGGER before_update INSTEAD OF UPDATE ON abcd BEGIN
618   CREATE TRIGGER after_update INSTEAD OF UPDATE ON abcd BEGIN
623   CREATE TRIGGER before_delete INSTEAD OF DELETE ON abcd BEGIN
627   CREATE TRIGGER after_delete INSTEAD OF DELETE ON abcd BEGIN
632   CREATE TRIGGER before_insert INSTEAD OF INSERT ON abcd BEGIN
636    CREATE TRIGGER after_insert INSTEAD OF INSERT ON abcd BEGIN
702     CREATE TRIGGER r1 INSTEAD OF DELETE ON v1 BEGIN
725     CREATE TRIGGER r2 INSTEAD OF INSERT ON v1 BEGIN
735     CREATE TRIGGER r3 INSTEAD OF UPDATE ON v1 BEGIN
749     CREATE TRIGGER trig1 INSTEAD OF DELETE ON v3 BEGIN
764   CREATE TRIGGER v2ins INSTEAD OF INSERT ON v2 BEGIN
784   CREATE TRIGGER r1 BEFORE INSERT ON t1 BEGIN