Kbase P123406: 4GL: Error (2873) executing a database trigger code.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/04/2007 |
|
Status: Unverified
SYMPTOM(s):
4GL: Error (2873) executing a database trigger code.
Cannot change cursor of buffer <buffer> when executing a trigger. (2873)
The code includes a FOR EACH loop against the table whose database event trigger is running.
CAUSE:
The buffer that holds the record for which the trigger is being executed cannot be advanced. No FOR EACH, FIND NEXT, etc may be executed in the database event trigger for that same buffer.
FIX:
Define a new buffer for the table whose trigger is being executed and use the new buffer to execute the cursor navigating code like a FOR EACH, FIND LAST, etc.