Kbase P126598: Error 12117 with Dynamics dynamic lookups
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/10/2007 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1x
Dynamics 2.1B
SYMPTOM(s):
Error 12117 with Dynamics dynamic lookups
Unacceptable datatype for LENGTH argument (12117)
Some dynamic lookups error with 12117.
CAUSE:
The INPUT-VALUE attribute is used in lookup.p getDataValue as an argument to the LENGTH function, and the LENGTH function expects a string as its argument. However, this attribute can only be determined at run time and its data type is the same as the datatype of its parent field. If the data type of the field is a decimal, then this will raise the 12117 error.
FIX:
Upgrade to OpenEdge 10.1B or later. As a work around in Dynamics 2.1B modify the following section of code in lookup.p getDataValue:
LENGTH(hLookup:INPUT-VALUE)
to:
cChar = hLookup:INPUT-VALUE.
LENGTH(cChar)