But what am i looking for is, I need a multi Select list Box Like a list box displays A ,B,C,D,E,F,G, H, I ......... From this I should be able to select Mulitiple values. can you tell me in more detail..
Thanks Texas
May 23, 2005, 02:43 PM
Tim J
I learned how to do this at the Summit!
TABLE FILE EMPDATA SUM SALARY BY TITLE -IF &DIV0 LT 1 THEN GOTO NOLOOP; WHERE DIV EQ '&DIV1' -SET &CNT = 2; -LOOP -IF &CNT GT &DIV0 GOTO NOLOOP; OR '&DIV.&CNT' -SET &CNT = &CNT + 1; -GOTO LOOP -NOLOOP END
Notes (DIV is parameter selected from multi-select box): &DIV0 = How many selected (&<fieldname>0 is reserved for this information!) &DIV1 = First Selected &DIV2 = 2nd selected, etc
May 23, 2005, 02:53 PM
Tim J
View my code I submitted in the earlier email through Focal Point, not the emailed version. Some of the ampersands did not show up in the email.
Thanks, Tim
May 23, 2005, 08:08 PM
TexasStingray
delvegas,
what version of WebFOCUS are you usung. Dev Studio with resource layout gives you a gui to create them. You create your report and set up a where statement using 'Equal to Multiple' and parameter.
May 24, 2005, 06:04 PM
Lloyd
Tim J --That's Interesting, this is the way I was taught to do it:
-IF &FIELD EQ '$*' THEN GOTO SKIP_FIELD; -IF &FIELD.EXISTS THEN GOTO FIELD1 ELSE GOTO FIELD2; -FIELD1 WHERE CPY_ID EQ &FIELD -IF &FIELD0.EXISTS THEN GOTO FIELD_START ELSE GOTO FIELD2; -FIELD_START -REPEAT FIELD2 FOR &COUNTERA FROM 2 TO &FIELD0; OR &FIELD.&COUNTERA -FIELD2 ; -SKIP_FIELD Pretty similar, but different. Anyone know which is the preffered/Better method? Are there any gotchas in the way I'm doing it?This message has been edited. Last edited by: <Mabel>,