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. > > >
