Subject Re: [firebird-support] Re: Maintain Summary Table with Database Trigger
Author unordained
---------- Original Message -----------
From: "JackR" <jack@...>
> In my
> program, before making a mass insert, update or delete, I will set the
> triggers to INACTIVE and then set the field in the status table at
> then end of processing. Rebuilding the summary table will then happen
> the next time the data is needed. How can I use a context variable to
> better accomplish my purpose?
------- End of Original Message -------

Oh, that. I misunderstood Vlad, then. I now think he was telling you this would
be better than activating/deactivating triggers:

create trigger ... as
if (rdb$get_context('USER_TRANSACTION', 'notrigger') = '1') then exit;

Before doing mass updates,

execute block as
rdb$set_context('USER_TRANSACTION', 'notrigger', '1');