It is for calling (legacy use) a "command Block" that is a part of a "procedure file".
Think of the following virtual file called abc.apx (or abc.app) depending on whether it is codelocked or not. <begin file> $command Proc1 pause 2 using .%1 return $command Proc2 pause 2 using .%1 return $command Proc2 pause 2 using .%1 return <end file> Then from another command or procedure, we call Proc2 using the following syntax run Proc2 in abc.apx using 'hello world' ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, February 11, 2008 11:12 PM Subject: [RBASE-L] - Re: Syntax for run select > 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. >> >> >> >> >> >> >> > >> >> >> >
