Subject Re: Maintain Summary Table with Database Trigger
Author JackR
Vlad,
I don't understand how a context variable would be helpful in this situation. Following on from this thread, I will set a field to null in a status table from triggers on the detail or subdetail tables for insert, update or delete. If someone updates one of those tables from a db admin tool like IBExpert, the trigger will execute. 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?

Thanks

Jack

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

> Context variables are way better for such usage
>
> Regards,
> Vlad
>