Hello! I wrote this in one sql file: Code (Text): CREATE TRIGGER t1 after UPDATE OF surname ON m WHEN (OLD.idm=1) BEGIN UPDATE m NEW.mname='trigger1'; END t1; and got: TRIGGER t1 compiled Warning: execution completed with warning Then I wrote this to other sql file: Code (Text): UPDATE m SET msurname='SURNAME_UPDATED' WHERE imd=1; and when running that got : trigger t1 is invalid PLEASE, why is t1 INVALID? Where is the mistake? Many thanks!!!