[SOLVED] retreive values from multiselect drop down list, hold in a temporary table
I am having a multiselect listbox named "listbox". The list box holds the values as "DDD-CC-IIII". So if there are three items selected in listbox by user on submitting the form, i need to hold in a table like below. Say Item1 in listbox->DDD-CC-III Item2 in listbox->DDD-CC-III Item3 in Listbox->DDD-CC-III
Now, I need an output like
Hold file or any other file/table such as Columns DDD, CC, IIII containing values like |DDD|CC|III |DDD|CC|III |DDD|CC|III
containing 3 rows and I need to use it for further processing. To achieve this, I am calling a fex file which in turn retrieve the selected values from the list box thro a repeat loop and assigning the splitted values to the dynamic variables set thro GETTOK function. Now, I am stuck with how to move this dynamic SET variables to TABLE/FILE/or a hold.
Please find below my code:
SQL SQLMSS PREPARE SQLOUT2 FOR SELECT * FROM PMR_RPT_PMTN_ITEM_DISC END
By this code above, I could able to get all the parameters that the user select in the UI and I could able to store them in the hold file. Thanks a lot!This message has been edited. Last edited by: Sivakumaran Elangovan,
Webfocus 7.6 Excel, HTML, PDF
June 07, 2013, 06:54 AM
Sivakumaran Elangovan
Ebaig, But I would like to know how this filedef works.. i wanna know in detail about the usage.
You'll find all yu need to know about FILEDEF in documentation. Alternatively go to the IBI tech support site and search on FILEDEF. You get several pages of hits.
WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF