Kbase P23811: Results from a DECIMAL field are truncated by the SQL-92 CASE function to an INTEGER value
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/09/2008 |
|
Status: Verified
SYMPTOM(s):
Results from a DECIMAL field are truncated by the SQL-92 CASE function to an INTEGER value
FACT(s) (Environment):
Progress 9.1x
All Supported Operating Systems
CAUSE:
Bug# OE00072319
FIX:
Option #1
Upgrade to OpenEdge 10.0A or later
Option #2
The workaround is to use the DECODE function.
Note that all values in the DECODE function need to be noted as decimals, otherwise the result will be an integer.