Focal Point
Selecting multiple values from a drop down list

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8861007371

June 26, 2006, 02:24 PM
Adolf Mergulhao
Selecting multiple values from a drop down list
WHERE FR_CLRCAT EQ '&FR_CLRCAT.(FIND FR_CLRCAT IN RFIFLTREC).FR_CLRCAT.';

I am using the above in a program, but this only allows the selection of one , is there a way of doing multiple selection from a listing i.e if the list shows 5A,5B,6A,6B selecting 5A and 6B


Webfocus 7.6.2 on Windows Enterprise 2003 Server and
Webfocus 7.6.2 on HP Unix Server
June 26, 2006, 03:11 PM
Prarie
FR_CLRCAT EQ '&FR_CLRCAT.(AND(FIND FR_CLRCAT IN RFIFLTREC)).FR_CLRCAT.';


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
June 27, 2006, 03:19 AM
Adolf Mergulhao
Thanks


Webfocus 7.6.2 on Windows Enterprise 2003 Server and
Webfocus 7.6.2 on HP Unix Server
June 27, 2006, 03:30 AM
Adolf Mergulhao
quote:
Originally posted by Prarie:
FR_CLRCAT EQ '&FR_CLRCAT.(AND(FIND FR_CLRCAT IN RFIFLTREC)).FR_CLRCAT.';


(FR_CLRCAT EQ &FR_CLRCAT.(OR(FIND FR_CLRCAT IN RFIFLTREC)).FR_CLRCAT.);
I used teh one above what's the difference that AND and OR makes


Webfocus 7.6.2 on Windows Enterprise 2003 Server and
Webfocus 7.6.2 on HP Unix Server
June 27, 2006, 12:24 PM
Prarie
AND means you want ALL of the selection in your Where statement included.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003