Kbase P124350: Calculated fields in updateable SmartDataBrowsers cause issues
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/22/2008 |
|
Status: Verified
SYMPTOM(s):
Using static SmartDataBrowser (SDB)
SDB is updateable
SDB contains calculated fields
Adding new row
Initial values are not populated and the new row is blank
Other runtime errors may occur
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
Windows
CAUSE:
Bug# OE00076393
FIX:
Workarounds:
1. Move the calculated field to the SmartDataObject (SDO) instead. In most cases this is the better practice since the calculated field itself is likely will be re-used in multiple objects anyway.
2. Enclose the expressions for the calculated fields in parenthesis.
For example:
Qty * Price @ deExtendedPrice
should be changed to:
(Qty * Price) @ deExtendedPrice
The AppBuilder's Expression Builder does not verify this syntax. As a result, it is possible to enter an expression in the Expression Builder that will result in the SDB not working as expected.