Kbase P27259: Validation is fired too soon when writing record to database using SmartDataObject
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/07/2008 |
|
Status: Unverified
SYMPTOM(s):
Validation is fired too soon when writing record to database using SmartDataObject
Sequence value is never retrieved because database trigger doesn't fire
Record validation fails in the SDO
FACT(s) (Environment):
Progress 9.1D
Progress 9.1E
OpenEdge 10.1x
All Supported Operating Systems
CAUSE:
In the SDO, the field was set to "Inherit Dictionary Validation Expression".
Therefore the validation is fired on the RowObjUpd temp-table before the record is even written to the database.
Since nothing is written to the database, database triggers will not fire.
FIX:
Switch off Inherit Dictionary Validation Expression for the field in the SDO.
(in SDO, go to query properties -> fields -> advanced and toggle "Inherit Dictionary Validation Expression" OFF)