Kbase P123196: Overflow error when inserting a decimal value through SQL-92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/2/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
SYMPTOM(s):
Overflow error when inserting a decimal value through SQL-92
Overflow error when updating a decimal column through SQL-92
Overflow error when inserting a numeric value through SQL-92
Overflow error when updating a numeric column through SQL-92
Overflow error (7485)
The database tables have been created through 4GL / ABL
CAUSE:
The SQL-Width (precision) of the decimal / numeric column is too small.
FIX:
Increase the SQL-Width of the decimal / numeric column through the Data Dictionary.
For example if the SQL-Width is set to 9, then the decimal number can only contain 9 digits: 1234567,89 or 123,456789