Kbase P122962: Result of LOOKUP function with embedded SUBSTITUTE call can not be captured in DECIMAL
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/03/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
Calling LOOKUP function
Catching result in DECIMAL variable
LOOKUP call has SUBSTITUTE function embedded as first parameter
Unable to complete automatic conversion of DECIMAL value--use the DECIMAL function. (5728)
CAUSE:
This is a known issue being investigated by Development
FIX:
Workarounds:
- Use an intermediate character variable to handle the SUBSTITUTE() before calling LOOKUP()
- Use an INTEGER variable to capture the result of the LOOKUP() instead of using a DECIMAL