Kbase P28164: Calculated fields not updated when setAutoCommit is set to F
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/06/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Calculated fields not updated when setAutoCommit is set to FALSE in SDO
When "setAutoCommit" is set to FALSE in an SDO, then calculated fields are not processed untill the actual command has been given to commit the data to the database. This happens only with dynamic SDB's
CAUSE:
The procedure (DATA.CALCULATE) that recalculates a calculated field in the SDO is a DB-REQUIRED procedure, and has to remain so. SDO calculated fields are intended to be used for calculations that require database interaction and will thus only be updated when the data is actually committed to the database.
This is not a bug. This is the way that SDOs were designed to work.
FIX:
When interactively calculated fields are required, they should be included in the SDB as SDB calculated fields.