Kbase P46908: 4GL/ABL: Table WRITE Triggers do not fire in the expected order.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/08/2009 |
|
Status: Verified
SYMPTOM(s):
4GL/ABL: Table WRITE Triggers do not fire in the expected order.
Schema trigger execution is not in the expected order.
Database schema triggers are not firing in the order of associated table appearance.
FACT(s) (Environment):
Code includes a sequence of statements that cause WRITE events for several tables.
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
CAUSE:
The Progress table WRITE event triggers fire when the associated table records are released. The order of the automatic release of records is unpredictable.
FIX:
To control the order of table WRITE event trigger execution, use the RELEASE statement for the associated table record or put the code generating the WRITE event in a separate transaction.