I have used a double list control in webfocus version 7.6.1.

I am getting the value in the below format
'PP Test TR' OR 'PP Test TR' OR 'PP SMS Level' OR 'PP SMS Level'.

I need the value in the below format to pass in a oracle procedure.

'PP Test TR','PP Test TR','PP SMS Level','PP SMS Level'.

Please help.

Thanks in advance!

This message has been edited. Last edited by: <Kathryn Henning>,

I use 7.7.03, and the only way I know this is to edit the source of the htm file, find the operation="" attribute of the tag that refers to the control, and make it

 operation=",". 

You can use STRREP to replace hte OR with ,

 
-SET &ValueLength   = &Value.LENGTH;
-SET &ValueAdj      = IF &Value CONTAINS ' OR ' THEN STRREP (&Value.LENGTH, &Value, 3, ' OR ', 1, ',', &Value.LENGTH, 'A&ValueLength.EVAL') ELSE &Value;
 

Thanks MattC.

Its working and usefull.

Very Good!

I had to do a lot of that in one of my programs as I had a lot of multi-select parameters being passed to SQL in Oracle.