I am trying to get the syntax below to prompt me twice for field value. Want to use an OR in a where clause with Parameters. It seems that the follow should work but I only get prompted once. Can someone please assist. WHERE END_DATE EQ '&END_DATE' OR '&END_DATE';

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

Just use distinct variable names, such as &DATE1 and &DATE2.

WHERE END_DATE EQ '&DATE1' OR '&DATE2';

Keep Smiling

How would you do the Date2. Would you create a define or print the field twice changing one of the fields to Date2.

quote:

END_DATE' OR '&END_DATE';

Just -DEFAULT them both. Are you using Auto Prompting of have you created a lauch page for this fex?

I will be creating a launch page once I get it to work.

I created a define.

The DEFINE would use &DATE1 and &DATE2, as would the launch page...

One of many ways (this one's explicit):

DEFINE FILE MyFile
ShowThisRecord/A3 = IF END_DATE EQ &DATE1 OR END_DATE EQ &DATE2 THEN 'YES' ELSE 'NO' ;
END
TABLE FILE MyFile
DO THIS
WHERE ShowThisRecord EQ 'YES'

So many other ways...

I always go to the GUI to determine the syntax for a Multi-Select OR. I always forget because I do not use it that much. The syntax is different based on whether it is a static list or a dynamic list that comes from a master.

  
TABLE FILE CAR
PRINT 
     COUNTRY
     CAR
     MODEL
HEADING
""
FOOTING
""
WHERE COUNTRY EQ &COUNTRY.(OR(<C1Text,C1Value>,<England,ENGLAND>)).Country.;
WHERE CAR EQ &CAR.(OR(FIND CAR,CAR IN CAR)).Car.;
ON TABLE SET PAGE-NUM OFF 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
$
ENDSTYLE
END

Thanks Doug, the define worked but the simple distinct variable names worked just as well. Much easier.

Also thanks Mighty Max, I will experiment with the GUI. Issue solved.