Is there a way to give the user a choice when they choose dates for parameters in a web page so they can choose NE or EQ. Basically can you parameterize the NE or EQ?

Dan

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

Sure, you could make that another variable and concatenate the 2 variables in the WHERE statement.

Simple example below, but you can make it as fancy as you like with an HTML launch page.

Best regards,
Sandeep Mamidenna

 
-*
-PROMPT '&FLD_OPR.Select Filter Operation (EQ/ NE / GT).','A2'
-PROMPT '&FLD_VAL.Select Filter Value for SEATS(2 /4 / 6).','A1'
-*
-SET &WHR = &FLD_OPR || ' ' | &FLD_VAL;
-*
TABLE FILE CAR
PRINT MODEL  SEATS
BY COUNTRY
WHERE SEATS &WHR.EVAL
END
-EXIT

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

Indeed, almost anything can be parameterized.
It sometimes needs a bit of extra coding, sometimes it is just a matter of using the parameter.
It is one of the great advantages of (Web)Focus.