Kbase 22010: "@<fieldname>" Error with Calculated Fields In a SDB
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/05/2002 |
|
SUMMARY:
You can encounter the following error when you define the formula for a calculated field within a SmartDataBrowser (SDB):
"Calculated fields in smartbrowsers must be named fields. This is
achieved by specifying "@<fieldname>" after the calculated field
expression. "<fieldname>" is a variable of correct datatype defined
elsewhere (usually in the definition section) in the same
smartbrowser."
If you haven't already defined the field name, you will receive an unknown field message when you click "OK" in this dialog. But, your calculated field will be reserved."
SOLUTION:
You have to ensure that:
a) The variable has been defined in the Definition Section
b) You're using the variable like: @ var-name
(be sure that there's a space between "@" and the variable)
References to Written Documentation:
Progress Knowledge Base Solutions:
15050, "How To Refer to a Calculated Field in a SmartBrowser"
19760, "ADM2 - Calculated Fields/SDB with Updatable Source Fields"