Kbase P145959: ROW-STATE is set to 'ROW-MODIFIED' when a row field is updated with its initial value
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/20/2009 |
|
Status: Verified
SYMPTOM(s):
ROW-STATE is set to 'ROW-MODIFIED' when a row field is updated with its initial value
Even if the before-image table row and after-image table row contain the same row, the row are flagged as 'ROW-MODIFIED'.
FACT(s) (Environment):
TRACKING-CHANGES attribute is set to TRUE
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
This is an expected behavior.
The trap for a change ignores if the value being set in is a new one or not.
It simply checks for writes to the temp-table database. In fact,when creating a new row, both created and modified events fire. However, the ROW-STATE of the before-image will remain as ROW-CREATED.
FIX:
May you expect ROW-STATE set to ROW-MODIFIED when a row has actually changed, not just resulting from a write trigger that fired, use a callback routine on the ROW-UPDATE event.