Focal Point
multi select List Box

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

May 20, 2005, 09:18 PM
<delvegas>
multi select List Box
Hi
Can anybody give code for multi Select List box.

I need to populate multiselect list box from data retrieved from other table. so I dont know how to create Multi Select list box

Thanks
May 21, 2005, 03:41 AM
TexasStingray
check my popup.zip in post<br /> https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5141028331
/r/9351028331#9351028331

This message has been edited. Last edited by: Kerry,
May 23, 2005, 02:22 PM
<delvegas>
Hi TexasStringray
Thanks a lot

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>,
May 24, 2005, 07:59 PM
<delvegas>
Lloyd and Tim J
Thanks a lot, appreciated guys