Kbase P24918: What is the scope of the 4GL DISABLE TRIGGERS statement?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/12/2005 |
|
Status: Unverified
GOAL:
What is the scope of the 4GL DISABLE TRIGGERS statement?
FIX:
Once a Progress database trigger is disabled with a Progress 4GL DISABLE TRIGGERS statement, it remains disabled for the duration of the procedure that issued the DISABLE TRIGGERS statement. Other users who are not running the code which disabled the triggers will still cause the triggers to fire.
Thus if ProcA.p executes the statement "DISABLE TRIGGERS FOR LOAD OF customer.", then from that point on, any and all subsequent updates to the customer table for that user will not fire its write trigger as long as ProcA.p is still running regardless whether the updates come from ProcA.p itself, one of its internal sub-procedures or any other persistent or non persistent procedure regardless whether it was called by ProcA.p or some other internal or external procedure.