Kbase P8976: FIND statement returns an error message in the AS400 joblog.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/26/2010 |
|
Status: Unverified
SYMPTOM(s):
When using FIND statement, it is possible for the FIND to fail with an error message in the AS400 joblog.
The error message is "Key mapping error on member <membername>".
FACT(s) (Environment):
Progress 9.1C
Progress/400 DataServer
CAUSE:
Bug# OE00080220
FIX:
Workaround possible : Assign the compound selection criteria to a variable and then perform the FIND on the variable.
i.e.: FIND FIRST table WHERE table.field = ("yes" = string(yes)) NO-LOCK.
becomes:
DEF VAR log1 AS LOGICAL.
log1 = ("yes" = STRING(yes)).
FIND FIRST table WHERE table.field = log1 NO-LOCK.