Jim Good idea. I have never even looked at the connect/pack. Would have to test this out. I problably could figure out some way of doing a conditional look as to whether to run the sp or not, mayber store it in the db ????. This would keep all the different command/script files headache out of the picture. Hmmm... interesting.
Jim --- "James (Jim) Bentley" <[EMAIL PROTECTED]> wrote: > JimL, > Wouldn't the following "ON" syntax accomplish what you want especially > if you "CMD" file contains: > "RUN SELECT USING parmlist SELECT SYS_PROC_SRC FROM SYS_PROCEDURES > WHERE SYS_PROC_NAME = 'procedurename' > +----------------------------- ON CONNECT/PACK > --------------------------------+ > � > � > � Use the ON CONNECT/PACK command to execute a command file before > or � > � after connecting to or packing a database. > � > � > � > � _ BEFORE indicates the command file should be run before the > CONNECT/PACK. � > � _ CONNECT indicates the command file should be run when connecting > a � > � database. > � > � _ FIRST indicates the command file should be run on the first > connect � > � only. > � > � _ PACK indicates the command file should be run when packing > a database. � > � _ cmdfile specifies the name of the command file to execute. > � > � > � > +------------------------------------------------------------------------------+ > +--------------------------------- SYNTAX > -------------------------------------+ > � > � > � > � > � +---------- CONNECT + > � > � �+ BEFORE � � > � > � ON �+ FIRST + + RUN cmdfile > � > � +------------ PACK -+ > � > � + BEFORE + > � > � > � > +------------------------------------------------------------------------------+ > > -- > Jim Bentley > American Celiac Society > [EMAIL PROTECTED] - email > (973) 325-8837 voice > (973) 669-8808 Fax > > > ---- "Ben Petersen" <[EMAIL PROTECTED]> wrote: > > Jim, > > > > What if you called an rmd file that only had one line to call > > your > > procedure? > > > > Ben Petersen > > > > > > > > On 25 Jul 2002, at 7:52, Jim Limburg wrote: > > > > > G-Day all > > > > > > I submitted the following to the RDCC... would this be something > > > that you'all would like to see as well? > > > > > > We have the capability to run a filespec from the Command > > line like: > > > C:\RBTI\RBDOS65\RBASE65.EXE -oc:\rbd65\rbase.cfg -r file2run.rmd > > > > > > 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 > > > > > > I'm not sure if you can get creative enough to let me pass > > parameters or not, > > > but that would a great feature as well. Maybe > > > C:\RBTI\RBDOS65\RBASE65.EXE -oc:\rbd65\rbase.cfg -r > -pstoredprocname(par1,par2) > > > > > > 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. > > > > > > __________________________________________________ > > > 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/ > > > > > > > > > ================================================ > > 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/ > > > ================================================ > 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/
