07.05.2018 7:43, 'Mr. John' mr_johnmr@... [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 variable dummy integer;
BEGIN
dummy = RDB$SET_CONTEXT('USER_TRANSACTION', 'DO_NOT_FIRE_TRIGGERS', 'YES');
UPDATE TABLE1 set FIELD1=0 WHERE FIELD1=1;
dummy = RDB$SET_CONTEXT('USER_TRANSACTION', 'DO_NOT_FIRE_TRIGGERS', 'NO');
END


--
WBR, SD.