Lines Matching refs:BEFORE

14 # These tests ensure that BEFORE and AFTER triggers are fired at the correct
83     CREATE TRIGGER before_update_row BEFORE UPDATE ON tbl FOR EACH ROW
126     CREATE TRIGGER delete_before_row BEFORE DELETE ON tbl FOR EACH ROW
154     CREATE TRIGGER insert_before_row BEFORE INSERT ON tbl FOR EACH ROW
284 # Check execution of BEFORE programs:
289     execsql "CREATE TRIGGER the_trigger BEFORE [string range $statement 0 6]\
329   CREATE TRIGGER tbl_after_update_cd BEFORE UPDATE OF c, d ON tbl
350              {t1 BEFORE INSERT ON tbl WHEN new.a > 20} \
351              {t2 BEFORE INSERT ON tbl WHEN (SELECT count(*) FROM tbl) = 0} ]
395   CREATE TRIGGER tr1 BEFORE INSERT ON tblA BEGIN
399   CREATE TRIGGER tr2 BEFORE INSERT ON tblB BEGIN
420   CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl
438   CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl