Kbase P99952: Overflow error when updating a calculated decimal field using SQL-92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/2/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Overflow error when updating a calculated decimal field
Overflow error (7485)
The decimal field is a calculated field
The result of a calculation is used to update the field
Only integers are used in the calculation
Using a SQL-92 client
CAUSE:
The result of the calculation is greater than 2147483647, which is the maximum value for an integer.
FIX:
Use decimal values in your calculation, e.g.: Instead of multiplying by 100, use 100.0 .
This will force the SQL-92 engine to use decimals in the calculation instead of integers.