I take that back.. Listen carefully It worked as I sent in the previous email, but at first it didn't. It behaved as you described but just for s---s and giggles, I added an additional parameter like:
run select using 'x','y','z' select cmddata from intcmd where cmdname = 'runkey' but did NOT alter the contents of cmdData in the 'RunKey' row, THEN it returned %1 and %2 values correctly, THEN AFTER removing the third parameter, it returned %1 and %2 values correctly, SO I think you could fairly conclude there is a little storage issue in there that you should address to the RDCC. But in the meantime, you have my 'Accidental' workaround. You're welcome ;-) Mike ----- Original Message ----- From: "Bill Downall" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, July 27, 2011 3:18 PM Subject: [RBASE-L] - RUN SELECT help : Pulling out hair time: : : Can someone please provide one or more examples of a working RUN SELECT : syntax with more than one parameter in the parmlist portion of the syntax? I : have tried 10 or 12 ways, and can get values for %1, but not for %2. Help : says I can have up to 18 parameter list values, but I'm getting stuck at : one. : : RUN SELECT USING firstparam, secondparam SELECT codeSnippet FROM : CodeSnippets WHERE CodesnippetID = .variable : RUN SELECT USING firstparam secondparam SELECT codeSnippet FROM CodeSnippets : WHERE CodesnippetID = .variable : RUN SELECT USING 'firstparam secondparam' SELECT codeSnippet FROM : CodeSnippets WHERE CodesnippetID = .variable : RUN SELECT USING 'firstparam, secondparam' SELECT codeSnippet FROM : CodeSnippets WHERE CodesnippetID = .variable : RUN SELECT USING '''firstparam'', ''secondparam''' SELECT codeSnippet FROM : CodeSnippets WHERE CodesnippetID = .variable : : I've also tried several versions with a variable to hold the whole : "parmlist", amper-variable and dotted-variable, with and without separate : doubled single-quote marks around parameters, : : Thanks in advance. : : Bill :
