Why does this work:

-DEFAULT &MYVALUE=10;

DEFINE FILE CAR ADD
NEWVALUE/I11=
	IF( &MYVALUE EQ 10) THEN 1
	ELSE IF( &MYVALUE EQ 20) THEN 2
	ELSE 3;
END

TABLE FILE CAR
PRINT 
     CAR.COMP.CAR AS '&MYVALUE'
	 NEWVALUE
END

But this doesn't?

-DEFAULT &MYVALUE='AAA';

DEFINE FILE CAR ADD
NEWVALUE/I11=
	IF( &MYVALUE EQ 'AAA') THEN 1
	ELSE IF( &MYVALUE EQ 'AAA') THEN 2
	ELSE 3;
END

TABLE FILE CAR
PRINT 
     CAR.COMP.CAR AS '&MYVALUE'
	 NEWVALUE
END

When looking at this through report painter, I see WebFOCUS is looking at &MYVALUE as a decimal even with I've clearly defaulted it as a string.

Is this a bug or by design?

This message has been edited. Last edited by: GavinL,

The IF statement is WebFOCUS code, not Dialogue manager code, so you're not comparing a variable to a value, you're comparing a value to a value. The following should work for both alpha and numeric values:

DEFINE FILE CAR ADD
NEWVALUE/I11=
     IF '&MYVALUE' EQ 'AAA' THEN 1
ELSE IF '&MYVALUE' EQ 'BBB' THEN 2
ELSE 3;
END

DOH!

Your the man as always..