Kbase P124661: Stars or nothing displayed if SQL-Width smaller than defined decimal field value in SQL-92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/29/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1B
SYMPTOM(s):
Stars or nothing displayed if SQL-Width smaller than defined decimal field value
SQL-Width of decimal field test2 is defined as 15 with 2 extents
UPDATE PUB.Customer SET test2='123456789.1' where "Cust-Num"=1;
SELECT test2 FROM PUB.Customer where "Cust-Num"=1;
If the field is an array stars are displayed
If the decimal field is not an array nothing is displayed
CAUSE:
This is a known issue
FIX:
Increase SQL-Width accordingly