Kbase P9207: SQL-92: Incompatable data type specified for Trigger OLDROW/NEWROW getValue/setValue method
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
Progress 9.1C
Progress 9.1B
SYMPTOM(s):
ErrorCode=-20175
Incompatable data type specified for Trigger OLDROW/NEWROW getValue/setValue method.
Error -20175 when firing an SQL-92 trigger.
CAUSE:
The col_num number and data type in the function getValue are not compatible.
FIX:
Correct the getValue function to match the col_num parameter to a valid data type.
Example:
NEW_CUST = (Integer) NEWROW.getValue(2, INTEGER);
col_num = 1 references an Integer field and col_num = 2 references a Character field. This would result in ErrorCode -20175.
The following corrects the problem:
NEW_CUST = (Integer) NEWROW.getValue(1, INTEGER);