Bill, Using 9.1(32) The following test worked:
The Run Select Statement: run select using 'x','y' select cmddata from intcmd where cmdname = 'runkey' The cmdData (varchar) value of row 'RunKey': pause 2 using .%1 pause 2 using .%2 return ----- 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 : --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
