Kbase P817: Error Inconsistent types (7481) with SQL-92 queries 2
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/11/2002 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.0x
FACT(s) (Environment):
Progress 9.1A
FACT(s) (Environment):
Progress 9.1B
SYMPTOM(s):
Inconsistent types (7481)
Using numeric functions
SQL-92
CAUSE:
There are some problems with SQL-92 functions that manipulate numbers and can lead to the error message. For example, the following query will fail if executed against sports2000 database on Progress 9 prior to 9.1C:
SELECT DECODE(ADJUSTMENT,0,0.0, amount / adjustment)
FROM pub.invoice
WHERE adjustment <> 0
FIX:
Upgrade to Progress 9.1C