Kbase P125898: Message "Can't change decimals of field . Field type is not decimal" updating a char field in Data
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/23/2009 |
|
Status: Verified
SYMPTOM(s):
Message "Can't change decimals of field <fieldname>. Field type is not decimal" updating a char field in Data Administration
Data Administration does not allow characters fields definition be updated
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
Bug# OE00170331
CAUSE:
This problem occurs when the field in question was created via SQL; i.e. in OpenEdge Architect. Java has no concept of the unknown value and thus assigns _field._decimals = 0 when the field is created.
FIX:
Run a program that locate the field in the _field table and assign the _decimals to the unknown value (?). Example:
FOR EACH _file WHERE _file._tbl-type EQ "T":
FOR EACH _field WHERE _field._file-recid EQ RECID(_file) AND
NOT (_field._data-type BEGINS "DEC") AND
_field._decimals NE ?:
_field._decimals = ?.
END.