Sql Table Editor and Multiselect functionality
How can we pass the selected row key using a bound parameter? I am trying to capture the selected row to a BR for further processing. I also have a supplied parameter to collect the bound parameter but it does not seem to work as a delimited list.
The active selected items will be passed to the defined Bound Parameter
field as a comma delimited list. The Bound Parameter format will be as: item1, Item2, Item3.
Please advise.
Thank You,
Indu
The secret sauce is putting [ square brackets ] around the parameter name that you want a delimited list from:
{DBExtenderName}{FuncName}{CommaDelimitedListOfValues=[|!pm_multipleValuesParam!|]}Then inside your BR, parse the comma seperated list into an array or list, whatever suits:
Dim arrValues As String() = args.NameValuePairs.XFGetValue("CommaDelimitedListOfValues", String.Empty).Trim().Split(","c)
