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
