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