Kbase 20424: Temp-Table Attribute Values and RCODE-INFORMATION
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/03/2010 |
|
Status: Verified
SYMPTOM(s):
Temp-table attributes return the default Progress values instead of the values specified in the DEFINE statement
Temp Table fields are defined with the wrong format
Temp table buffer field returns the wrong format
Temp table defined FORMAT ignored with dynamic programing
Temp table defined LABEL ignored with dynamic programing
Temp table defined INITIAL-VALUE ignored with dynamic programing
Temp table defined HELP ignored with dynamic programing
Cannot rely on Temp-tables definition of FORMAT, LABEL and HELP for a field
FACT(s) (Environment):
Progress 9.x
All Supported Operating Systems
CAUSE:
This is expected behavior.
By default, these attributes are not stored in the R-code when the procedure is compiled in order to save space in the Initial Values segment, and to limit the amount of data that is sent to and from an AppServer when using temp-table parameters. The exception to this rule is when a static 4GL construct in the same procedure requires the values to be available.
FIX:
Specify the RCODE-INFORMATION option on the DEFINE statement of the temp-table.
This will force storing FORMAT, LABEL, INITIAL and HELP information into the r-code at all times.