Lines Matching refs:TRIGGER

102       CREATE TRIGGER before_update_row BEFORE UPDATE ON tbl FOR EACH ROW 
111       CREATE TRIGGER after_update_row AFTER UPDATE ON tbl FOR EACH ROW 
120       CREATE TRIGGER conditional_update_row AFTER UPDATE ON tbl FOR EACH ROW
152       CREATE TRIGGER delete_before_row BEFORE DELETE ON tbl FOR EACH ROW
161       CREATE TRIGGER delete_after_row AFTER DELETE ON tbl FOR EACH ROW
186       CREATE TRIGGER insert_before_row BEFORE INSERT ON tbl FOR EACH ROW
195       CREATE TRIGGER insert_after_row AFTER INSERT ON tbl FOR EACH ROW
320     execsql "CREATE TRIGGER the_trigger BEFORE [string range $statement 0 6]\
325     execsql "DROP TRIGGER the_trigger;"
332     execsql "CREATE TRIGGER the_trigger AFTER [string range $statement 0 6]\
336     execsql "DROP TRIGGER the_trigger;"
355   CREATE TRIGGER tbl_after_update_cd BEFORE UPDATE OF c, d ON tbl
388   execsql "CREATE TRIGGER $trig BEGIN UPDATE log set a = a + 1; END;"
424   CREATE TRIGGER tr1 BEFORE INSERT ON tblA BEGIN
428   CREATE TRIGGER tr2 BEFORE INSERT ON tblB BEGIN
449   CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl 
467   CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl 
490     CREATE TRIGGER ai_tbl AFTER INSERT ON tbl BEGIN
544     CREATE TRIGGER au_tbl AFTER UPDATE ON tbl BEGIN
618   CREATE TRIGGER before_update INSTEAD OF UPDATE ON abcd BEGIN
622   CREATE TRIGGER after_update INSTEAD OF UPDATE ON abcd BEGIN
627   CREATE TRIGGER before_delete INSTEAD OF DELETE ON abcd BEGIN
631   CREATE TRIGGER after_delete INSTEAD OF DELETE ON abcd BEGIN
636   CREATE TRIGGER before_insert INSTEAD OF INSERT ON abcd BEGIN
640    CREATE TRIGGER after_insert INSTEAD OF INSERT ON abcd BEGIN
706     CREATE TRIGGER r1 INSTEAD OF DELETE ON v1 BEGIN
729     CREATE TRIGGER r2 INSTEAD OF INSERT ON v1 BEGIN
739     CREATE TRIGGER r3 INSTEAD OF UPDATE ON v1 BEGIN
753     CREATE TRIGGER trig1 INSTEAD OF DELETE ON v3 BEGIN