Philip,
No kidding! That's a great feature. I probably ignore those rdb$...
features mostly figuring that I will never need them. I just tried out
a couple of examples in IBExpert and it works very well. The variable
seems to go away on commit. If there was a longer term one, it might
also eliminate the need for the field in the status table but I will
definitely make use of it as it is.

Thanks for your explanation.

Jack


--- In firebird-support@yahoogroups.com, "unordained"
<unordained_00@...> wrote:

>
> ---------- 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
> begin
> if (rdb$get_context('USER_TRANSACTION', 'notrigger') = '1') then

exit;

> ...
> end
>
> Before doing mass updates,
>
> execute block as
> begin
> rdb$set_context('USER_TRANSACTION', 'notrigger', '1');
> end
>
> -Philip
>

[Non-text portions of this message have been removed]