Hi Mike, So you are saying, parameters can't be passed to a RUN SELECT as such. What then is the RUN SELECT USING syntax in the help file? A code snippet might help...
Regards, Ken ----- Original Message ----- From: MikeB Date: Monday, February 11, 2008 11:05 pm Subject: [RBASE-L] - Re: Syntax for run select To: [email protected] (RBASE-L Mailing List) > 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: > To: "RBASE-L Mailing List" > 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. > >> > >> > >> > > > > >
