ABLE FILE CAR PRINT CAR SALES RETAIL_COST WHERE SALES &OPTION2 RETAIL_COST;
Thank you for pointing that out. It works. It my bad that I didnt see code carefully. I also tried the following and that worked too.Since I knew none of the value is going to be null so I used following code for all and it worked too. However, foc_none is better way to go just in case if in future we get null value in the field.
SET &OPTION = &CTR.(<Positive,GT>,<Negitive,LT>,<ALL,IS>).OPTION.;
-*-SET &PASSVAL = IF &OPTION EQ 'GT' OR 'LT' THEN 0 ELSE 'NOT MISSING';
WebFOCUS 7.6.10 Windows HTML
October 14, 2010, 12:24 PM
I usually try to avoid mixing with DM codes. This makes GUI compatible.
WHERE (COLVALUE1 GT 0 AND '&OPTION' EQ 'FIRST') OR
(COLVALUE1 LT 0 AND '&OPTION' EQ 'SECOND') OR
('&OPTION' EQ 'ALL')