Kbase P24575: Error 247 when using nested IF ... THEN ... ELSE statements
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/6/2003 |
|
Status: Unverified
SYMPTOM(s):
** Unable to understand after -- "DISPLAY". (247)
Using nested IF ... THEN ... ELSE statements in a Calculated Field.
CAUSE:
Missing ELSE keyword at the end of the last IF statement.
FIX:
Add the missing ELSE keyword at the end of the statement.
For example the following will give a syntax error in a calculated field:
IF cTest = "AAA" THEN "AAA1" ELSE IF cTest = "BBB" THEN "BBB1"
To correct this, use the following statement:
IF cTest = "AAA" THEN "AAA1" ELSE IF cTest = "BBB" THEN "BBB1" ELSE ""