Thanks for the help, Mike -- and Anne, too. I listened carefully -- but somehow, didn't get to the giggling.
Thanks for the tip! I'll put together a sample for RBTI/RDCC. Bill On Wed, Jul 27, 2011 at 6:12 PM, Mike Byerley <[email protected]> wrote: > 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 > : > > >
