Subject | Deactivate triggers inside EXECUTE BLOCK |
---|---|
Author | Mr. John |
Post date | 2018-05-07T05:43:44Z |
Hi.I'm looking for a way to run a simple update on couple tables without calling triggers,something like this:
EXECUTE BLOCK AS
BEGIN
EXECUTE STATEMENT 'update RDB$TRIGGERS set rdb$trigger_inactive=1 where RDB$RELATION_NAME=''TABLE1'' ';
UPDATE TABLE1 set FIELD1=0 WHERE FIELD1=1;
EXECUTE STATEMENT 'update RDB$TRIGGERS set rdb$trigger_inactive=0 where RDB$RELATION_NAME=''TABLE1'' ';
END
but doesn't work
thanks