As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
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,