Kbase P19278: Can you override a session' write trigger
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/25/2003 |
|
Status: Unverified
SYMPTOM(s):
Can not update a table which is using a session trigger
Cycle in procedure calls detected in <procedure> while executing WRITE trigger for <table>. (2868)
Unable to override session trigger
Program X updates table A which has a write trigger.
The write trigger updates table B which has a write trigger and updates table A
Result: infinite loop if write trigger executes for table A from table B's write trigger
Table B has override for write trigger of table A, but it does not work
CAUSE:
The session write trigger can not be overridden.
FIX:
Rewrite the logic in the application.