At 07:52 AM 7/25/2002 -0700, Jim Limburg wrote:
>I would also like to see another switch -s for what I call silent mode...
>RBase
>would not come up in a window.. It would just run silent on the task bar and
>run the stored procedure and exit. I don't think - haven't tried - that I can
>use EXIT from a stored procedure to exit RBase.
Jim,
You can use CALL command to achieve your goals.
Basically, you run a stored procedure using the CALL command, or a
procedure can be run automatically using database Triggers. Procedures
run with triggers must be stored with no parameters.
A very simple example:
01. Create a startup DAT file with the following:
-- CallSTP.DAT
CONNect dbname IDENTIFIED BY ownername
SELECT (CALL DBCheck()) FROM AnyTable WHERE LIMIT=1
EXIT
In the above example, an SQL select statement is used to invoke a
maintenance routine. The use of WHERE LIMIT=1 causes the procedure
to run once and only once. Without this clause the stored procedure
would execute once for every matching row in the table. The AnyTable
can be any table in the database in this case. The only requirement is
that we must use a table in order to have a "healthy" SELECT clause.
For complete details on CALL, refer to http://www.RSyntax.com
02. Use the following parameters to start R:BASE as following:
RBASE65 -R -C CallSTP.DAT
You may want to modify above parameters accordingly.
Have Fun!
Very Best Regards,
Razzak.
================================================
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/
