I hope this is an easy one - I have struggled with this for the better part of a day (mainly trying different combinations and some searching of the documentation and forum) and have turned up no solution. I have a multi-select variable from a dynamic list in procedure A which is named &LF and the available selections are No selection, L or F. I have the same multi-select variable from a dynamic list in procedure B. These procedures can be run "stand alone" by entering the parameters (including selecting both L and F for the &LF parameter) and work perfectly. I also wanted to be able to drill down from procedure A to procedure B. However, when I try to drill down, procedure B fails with (FOC257) Missing quotes... To attempt to see what is going on behind the scenes by displaying what's in the variable - I run procedure A - it works and the variable contains 'L' OR 'F'. When I drill down to procedure B (WHERE statement that uses the &LF variable removed so it will run) and display the variable, it contains ''L'' OR ''F''. I assume the QUOTEDSTRING I added to the variable when I passed the parameters on the drill down is causing this extra set of quotes but it won't work with or without it (and I've tried a bunch of combinations).

This message has been edited. Last edited by: JDroke,

JDroke,

I had the same problem, check this out:
https://forums.informationbuilders.com/eve/forums/a/tpc/...331075992#8331075992

Thanks Hua for the reply. I don't think I can make that solution work in this case since in my case it's a multi-select variable which would make it hard (for me) to code the mask.

What I really need is a REPLACE function (like other languages have) where I can scan the variable for all occurences of two single quotes and replace them with one single quote (when two single quotes are there).

I found this (STRREP) which did the trick in my drill down procedure...

-SET &LF=STRREP(30,&LF,2,'''''',1,'''',30,&LF);

This message has been edited. Last edited by: JDroke,