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 STATEMENT 'update RDB$TRIGGERS set 
rdb$trigger_inactive=0 where RDB$RELATION_NAME=''TABLE1'' ';END

but doesn't workthanks
  • [firebird-support... 'Mr. John' mr_joh...@yahoo.com [firebird-support]
    • Re: [firebir... Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
      • Re: [fir... 'Mr. John' mr_joh...@yahoo.com [firebird-support]

Reply via email to