[RBASE-L] - RE: RUN SELECT help

[anne]

Bill I'm just guessing here but the two select commands after one another seems wrong.

RUN SELECT USING firstparam, secondparam FROM CodeSnippets WHERE CodesnippetID = .variable

-------- Original Message --------
Subject: [RBASE-L] - RUN SELECT help
From: Bill Downall <bdown...@downallconsulting.com>
Date: Wed, July 27, 2011 3:18 pm
To: rbase-l@rbase.com (RBASE-L Mailing List)

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