Ken, The syntax for which you refer is for passing parameters to another command file. When that scenario is present, RBase knows to look for the "Using" keyword and parses the data after. You will have to declare Vars before you run RUN SELECT and then access them within your stored code.
----- Original Message ----- From: <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, February 11, 2008 10:49 PM Subject: [RBASE-L] - Re: Syntax for run select > Razzak, > > Thank you for the reply, my original email wasn't clear. I understand the > syntax for the RUN SELECT and it works like a charm. I'm not interpeting the > help correctly, I want to pass parameters to the procedure and do not > understand the syntax. > > Thanks, Ken > > ----- Original Message ----- > From: "A. Razzak Memon" > Date: Monday, February 11, 2008 10:27 pm > Subject: [RBASE-L] - Re: Syntax for run select > To: [email protected] (RBASE-L Mailing List) > >> At 10:00 PM 2/11/2008, Ken wrote: >> >> >According to my interpetation of the documentation, this would >> be the syntax: >> > >> >RUN SELECT USING 'A B' SELECT VARCHAR_CMD from table where >> >name='name' -- where A and B are constants. >> > >> >This throws a syntax error. Any insight would be appreciated. >> >> >> Ken, >> >> A very simple example: >> >> Table Name: StoredCommands >> >> No. Column Name Attributes >> --- ------------------ ------------------------------------------ >> ------------ >> 1 CommandID Type : INTEGER >> Comment: Command ID >> 2 CommandFile Type : LONG VARCHAR >> Comment: Actual Command File >> >> Typical Syntax: >> >> RUN SELECT CommandFile FROM StoredCommands WHERE CommandID = nnnn >> >> Hope that helps! >> >> Very Best R:egards, >> >> Razzak. >> >> >> >
