Bob,
We
have set up our system to store these temporary $$$ at the workstaion level in a
the C:\WINDOWS\TEMP directory and then these files are deleted each time the
computer is started up and logged into the network. We use the network logon
script to do this.
If you
are using Windows 2000 you have to make a windows\temp
directory.
We
also have a dos batch file that runs nightly on the data directory to eliminate
any stray files.
The
following is used on application start up. as you can see we set the scratch
file directory right at application start up.
In
addition to this you can see the old commands we used to delete these file types
on application start up
--
DBSTART←
-- Connects database and sets various parameters. Issues error message←
-- and terminates application if database is unavailable←
←
-- THE FOLLOWING COMMAND ERASE TEMP FILES FROM THE LOCAL AND C DRIVES←
←
-- ERASE *.$$$←
-- ERASE c:\WINDOWS\TEMP\*.$$$←
←
set quote='←
set err var verr←
set var verr1 int←
←
set scratch c:\windows\temp←
←
connect breakdn ←
set var verr1 = .verr←
if verr1 ne 0 then←
cls←
set var xmsg text = 'Database Unavailable.'←
set var xmsg = (.xmsg + ' Error Code = ' + (ctxt(.verr1)))←
pause 1 using .xmsg at cen cen black on red←
exit←
-- Connects database and sets various parameters. Issues error message←
-- and terminates application if database is unavailable←
←
-- THE FOLLOWING COMMAND ERASE TEMP FILES FROM THE LOCAL AND C DRIVES←
←
-- ERASE *.$$$←
-- ERASE c:\WINDOWS\TEMP\*.$$$←
←
set quote='←
set err var verr←
set var verr1 int←
←
set scratch c:\windows\temp←
←
connect breakdn ←
set var verr1 = .verr←
if verr1 ne 0 then←
cls←
set var xmsg text = 'Database Unavailable.'←
set var xmsg = (.xmsg + ' Error Code = ' + (ctxt(.verr1)))←
pause 1 using .xmsg at cen cen black on red←
exit←
Just
some other idea's for managing these files.
Steve
Breen
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 30, 2005 12:16 PM
To: [email protected]
Subject: [RBG7-L] - Re: $$$ files
Yes !!! Of course, the ERASE command. I went right by it while searching all the commands. Now the caveat.....it does work in an application if you exit with the "X", but if you have a button with an EXIT command it bypasses the "on close" commands in an RBA application. I am going to have to test this out more fully to see if this is a boo boo or just the way the EXIT command works. Maybe Razzak can enlighten us, as always. More experimentation is needed for sure.
Thanks for the tip, Jan.
Bob C.
"jan johansen" <[EMAIL PROTECTED]>
Sent by: [email protected]04/30/2005 12:41 PM
[email protected]
[email protected] (RBG7-L Mailing List) [RBG7-L] - Re: $$$ files
Bob,
Razzak recently posted this very topic.
I believe that the R:Base command would be
ERASE *.$$$
Jan
-----Original Message-----
From: [EMAIL PROTECTED]
To: [email protected] (RBG7-L Mailing List)
Date: Sat, 30 Apr 2005 12:01:45 -0400
Subject: [RBG7-L] - Re: $$$ files
Thanks, Bill - are you sure that DEL is a valid rbase command for files? I tried this in an application close and it didn't work, and I could not find it in the help files. I am trying to keep a tight lid on my programs and not get into too many CMD or Command routines outside of R:base - it just adds to the confusion on a big network. I was hoping to keep this all in a compiled app...
For now I will use your suggestion, though.
Bob C.
Bill Downall <[EMAIL PROTECTED]>
Sent by: [email protected]
04/30/2005 11:13 AM
[email protected]
[email protected] (RBG7-L Mailing List) [RBG7-L] - Re: $$$ files
Bob,
I have a little DOS batch file named DELCRAP.CMD
It runs occasionally as a "scheduled task."
It does not run through R:BASE, but through the command processor
CMD.EXE. Turns out all of the commands are also R:Base commands, so you
could concievably also run it at startup with an R:Base RUN command.
At the command line, if a $$$ file is "in use", it just gets skipped,
and all the others still get deleted. If you select a bunch of $$$ files
in explorer and "delete", at the first open file Windows gives up and
stops deleting any more, so this works a lot better.
REM DELCRAP.CMD
R:
cd \myappdir
DEL *.BAK
DEL *.$*
DEL *.DBG
DEL JUNK*.*
DEL *.VWR
EXIT
[EMAIL PROTECTED] wrote:
>
>
> I know I used to do this in DOS, but I am having a post-Friday night
> brain lock.
> On a cleanup from an application, I want to delete as many $$$ files as
> will allow. Wasn'e there a command in R:Base to delete files in the
> current directory? Why can't I remember this???
> How does anyone else clean up their directories?
> Thanks
> Bob C.
