Hey Larry
I now use CALL all the time and I thinks it's great.
What I didn't think about that you brought up though is that you have
to connect to the db first..duh.... Maybe it could read like:
C:\RBTI\RBDOS65\RBASE65.EXE -oc:\rbd65\rbase.cfg -r
-pdb2connect2,storedprocname(parameter1, parameter2)
That way it would connect to the database and run the stored procedure.
Wishful thinking
Jim
--- Lawrence Lustig <[EMAIL PROTECTED]> wrote:
> > What I would like to see, and I have many purposes for this is to have
> another
> > switch like the -o above. Call it -p and it would run a stored procedure
> for
> > the name that follows it.
> > Example:
> C:\RBTI\RBDOS65\RBASE65.EXE -oc:\rbd65\rbase.cfg -r -pstoredprocname
>
> Jim:
>
> CALL is a standalone statement in R:Base, as well as an expression operator,
> so you can put the following line all by itself in a command file:
>
> CALL StoredProcName()
>
> and then start R:Base running that file (of course, you need to connect a
> database first, or otherwise R:Base won't see any stored procedures).
>
> For passing parameters, you can either write them directly into your command
> file or get them from the environment:
>
> CALL StoredProcName((EnvVal('MyFirstValue')), (EnvVal('MySecondValue')))
>
> You can place values into the environment from outside R:Base using the
>
> SET Name=Value
>
> command in batch files, etc. Remember that EnvVal will always return your
> value as a string and R:Base stored procedures are type checked -- so if the
> SP is expecting an integer (for instance) you need to convert the value
> before passing it to the stored procedure.
> --
> Larry
>
> ================================================
> TO SEE MESSAGE POSTING GUIDELINES:
> Send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: INTRO rbase-l
> ================================================
> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: UNSUBSCRIBE rbase-l
> ================================================
> TO SEARCH ARCHIVES:
> http://www.mail-archive.com/rbase-l%40sonetmail.com/
__________________________________________________
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
