Razzak, using the RUN SELECT syntax I'm still unclear if it possible, or not, to pass parameters via a USING clause.
Regards, Ken ----- Original Message ----- From: "A. Razzak Memon" Date: Tuesday, February 12, 2008 9:43 am Subject: [RBASE-L] - Re: Syntax for run select To: [email protected] (RBASE-L Mailing List) > At 08:02 AM 2/12/2008, Lawrence Lustig wrote: > > >Uh oh! Have multi-block procedure files been deprecated? > > No. Have you tested and verified it yourself? > > > >BTW, this syntax is in the latest help file that I checked: > > > >RUN SELECT USING parmlist SELECT VARCHAR clause > > I think the connecting dots and lines need a little adjustment > for the syntax. > > In reference to running stored command from a "table" using > the RUN SELECT command, try the following 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 > > Have fun! > > Very Best R:egards, > > Razzak. > > >
