Re: [firebird-support] Deactivate triggers inside EXECUTE BLOCK

thanks On Monday, May 7, 2018, 12:43:40 PM GMT+3, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: 07.05.2018 7:43, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > I'm looking for a way to run a simple update on couple tables

Re: [firebird-support] Deactivate triggers inside EXECUTE BLOCK

07.05.2018 7:43, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > I'm looking for a way to run a simple update on couple tables without calling > triggers Modify your trigger to check some context variable and skip actions. Then do something like that: EXECUTE BLOCK AS declare

[firebird-support] Deactivate triggers inside EXECUTE BLOCK

Hi.I'm looking for a way to run a simple update on couple tables without calling triggers,something like this: EXECUTE BLOCK ASBEGIN EXECUTE STATEMENT 'update RDB$TRIGGERS set rdb$trigger_inactive=1 where RDB$RELATION_NAME=''TABLE1'' ';   UPDATE TABLE1  set FIELD1=0 WHERE FIELD1=1; EXECUTE