Consultor Eletrônico

Status: Unverified

FACT(s) (Environment):

Progress 9.1x

SYMPTOM(s):

Cannot specify the number of DECIMALS in decimal fields in a
dynamic temp table.

Using the ADD-NEW-FIELD method with a dynamic TEMP-TABLE.

Setting several decimal digits in a format attribute doesn't
mean that the field handles the specified number of decimal digits.

Syntax for ADD-NEW-FIELD does not allow specifying handles ie number
of decimals (like in the "ADD FIELD" window of the Data Dictionary).

CAUSE:

Progress handles temp table decimal fields differently to the way it handles database decimal fields. Progress handles decimal fields in
temp-tables in the same way it handles decimal variables.

FIX:

In variables Progress maintains the whole value but in a display
statement it will truncate the corresponding display value to the specified format or to the default format of decimal type. The whole value stored in the
decimal variable/temp-table field will be used in an assign statement.