Hi
But if your Scratch files are stored in the
Windows Temp dir will this delete those
files?? or am I missing something?
Marc
> Create a command file to do the deletions:
>
> -- DelDollar.rmd
> PAUSE 3 USING 'Cleaning up!' CAPTION 'Working'
> DEL *.$$$
> DEL 0*.rmd
> DEL 1*.rmd
> DEL 2*.rmd
> DEL 3*.rmd
> DEL 4*.rmd
> DEL 5*.rmd
> DEL 6*.rmd
> DEL 7*.rmd
> DEL 8*.rmd
> DEL 9*.rmd
> CLS
> RETURN
>
> At the R> prompt, connected in as database owner,
>
> R>ON FIRST CONNECT RUN DelDollar.rmd
>
> Now, if everyone gets out of the database, the first user in will see the
file clean up go by.
>
> --- Javier Valencia <[EMAIL PROTECTED]> wrote:
>
> > Albert:
> > Can you elaborate on the ON FIRST CONNECT?
> >
> > What I have done so far is to change the exit code as follows:
> >
> > -- Other code here
> > SET VAR vconnections =(CVAL('CONNECTIONS'))
> > DISC
> > IF vconnections = 1 THEN
> > DEL *.$$$
> > DEL 0*.rmd
> > DEL 1*.rmd
> > DEL 2*.rmd
> > DEL 3*.rmd
> > DEL 4*.rmd
> > DEL 5*.rmd
> > DEL 6*.rmd
> > DEL 7*.rmd
> > DEL 8*.rmd
> > DEL 9*.rmd
> > ENDIF
> > EXIT
> >
> > Note that you have to use the (CVAL('CONNECTIONS')) before you
disconnect
> > otherwise it will show 0 (zero); also, if a session was terminated
> > abnormally, the session will show in the number of connections.
> > Javier,
> >
> > Javier Valencia, PE
> > President
> > Valencia Technology Group, L.L.C.
> > 14315 S. Twilight Ln, Suite #14
> > Olathe, Kansas 66062-4578
> > Office (913)829-0888
> > Fax (913)649-2904
> > Cell (913)915-3137
> > ================================================
> > Attention:
> > The information contained in this message and or attachments is intended
> > only for the person or entity to which it is addressed and may contain
> > confidential and/or privileged material. Any review, retransmission,
> > dissemination or other use of, or taking of any action in reliance upon,
> > this information by persons or entities other than the intended
recipient
> > is prohibited. If you received this in error, please contact the sender
and
> > delete the material from all system and destroy all copies.
> > ======================================================
> >
> > -----Original Message-----
> > From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Albert
Berry
> > Sent: Monday, August 15, 2005 8:54 PM
> > To: RBG7-L Mailing List
> > Subject: [RBG7-L] - RE: Cloberring other people's $$$ files.
> >
> > Larry, Javier et al.
> > Perhaps this is a good use for an ON FIRST CONNECT applied to the
database.
> >
> > --- Javier Valencia <[EMAIL PROTECTED]> wrote:
> >
> > > Larry:
> > > This would explain some problem my users have been having when someone
> > else
> > > logged out early. Normally they all log in and log out at roughly the
same
> > > time so it has not been a huge issue yet. I could put code on the
logout
> > > routine to check whether there are other user logged in and if yes it
> > would
> > > not delete the *$$$ files, in other words the last user to log out
would
> > > delete all the temporary files...
> > > Javier,
> > >
> > > Javier Valencia, PE
> > > President
> > > Valencia Technology Group, L.L.C.
> > > 14315 S. Twilight Ln, Suite #14
> > > Olathe, Kansas 66062-4578
> > > Office (913)829-0888
> > > Fax (913)649-2904
> > > Cell (913)915-3137
> > > ================================================
> > > Attention:
> > > The information contained in this message and or attachments is
intended
> > > only for the person or entity to which it is addressed and may contain
> > > confidential and/or privileged material. Any review, retransmission,
> > > dissemination or other use of, or taking of any action in reliance
upon,
> > > this information by persons or entities other than the intended
recipient
> > > is prohibited. If you received this in error, please contact the
sender
> > and
> > > delete the material from all system and destroy all copies.
> > > ======================================================
> > >
> > > -----Original Message-----
> > > From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Lawrence
> > Lustig
> > > Sent: Monday, August 15, 2005 9:16 AM
> > > To: RBG7-L Mailing List
> > > Subject: [RBG7-L] - Cloberring other people's $$$ files.
> > >
> > > Although I set the scratch directory to the user's temp directory, I
still
> > > accumulate a lot of $$$ files in the startup directory in multi-user
> > > situations. To protect against this, I have always included an ERASE
> > *.$$$
> > > in
> > > command files (since R:Base never erases the open files from the
current
> > > session).
> > >
> > > Recently (with 7.1), I've noticed a couple of occurences in which I've
> > been
> > > able to clobber _another user's_ R:Base session by erasing all the $$$
> > files
> > > in
> > > the startup directory. In other words, files which R:Base used to not
> > erase
> > > are now eraseable from a different R:Base session.
> > >
> > > Has anyone else noticed a similar change? How do people deal with the
> > > danger
> > > of clobbering another session by erasing a temp file?
> > > --
> > > Larry
> > >
> > >
> >
> >
> > Albert Berry
> > Management Consultant
> > RR2 - 1252 Ponderosa Drive
> > Sparwood BC, V0B 2G2
> > Canada
> > (250) 425-5806
> > (250) 425-7259
> > (708) 575-3952 (fax)
> > [EMAIL PROTECTED]
> >
> >
>
>
> Albert Berry
> Management Consultant
> RR2 - 1252 Ponderosa Drive
> Sparwood BC, V0B 2G2
> Canada
> (250) 425-5806
> (250) 425-7259
> (708) 575-3952 (fax)
> [EMAIL PROTECTED]
>
>
