Lines Matching refs:BEFORE

16 # These tests ensure that BEFORE and AFTER triggers are fired at the correct
85     CREATE TRIGGER before_update_row BEFORE UPDATE ON tbl FOR EACH ROW 
128     CREATE TRIGGER delete_before_row BEFORE DELETE ON tbl FOR EACH ROW
156     CREATE TRIGGER insert_before_row BEFORE INSERT ON tbl FOR EACH ROW
286 # Check execution of BEFORE programs:
291     execsql "CREATE TRIGGER the_trigger BEFORE [string range $statement 0 6]\
331   CREATE TRIGGER tbl_after_update_cd BEFORE UPDATE OF c, d ON tbl
352              {t1 BEFORE INSERT ON tbl WHEN new.a > 20} \
353              {t2 BEFORE INSERT ON tbl WHEN (SELECT count(*) FROM tbl) = 0} ]
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