Kbase P10095: Database trigger causes error 2868 when recursive trigger invocations happen against the same record
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Database trigger causes recursive trigger invocations against the same record
Cycle in procedure calls detected in <procedure> while executing WRITE trigger for <table>. (2868)
CHANGE:
Application was modified and a single record (recid) is being recursively modified more than once within a database WRITE trigger
CAUSE:
This error is not only in place to protect the 4GL coder from themselves, Progress is not designed to be able to recursively run the same WRITE trigger on the same database record
FIX:
The application code must be modified to avoid recursive modification of the same record.