Hi all,
I have a system that creates a temporary file from an SQL statement for
reporting purposes. I create a temporary filename:
fname="tmp"+right(sys(3),5)+".dbf"
Then I do an SQL Select statement that ends with:
into table &fname
I do all my processing with that temporary file, including printing the
report, so I know the file is fine. The problem lies in deleting the file
at the end. I use the following code:
sele(fname)
use
dele file &fname
This seems to be working just fine here on my machine, but at our plant in
Mississippi (where this application is being used on a daily basis), they
seem to end up with a lotta files on their machine that start with "tmp"
followed by five numbers and ".dbf".
Any suggestions as to why these files may not be being deleted on their end?
It's not that the program is blowing up before the deleting should be
happening...the program is running through to completion just fine each
time. But for whatever reason, my temporary files aren't being deleted.
Thanks very much!
John
"Are you suggesting coconuts migrate?" - Guard #1
* All mail scanned by Norton AntiVirus. No AV software on your computer?
Remove me from your address book, please.
* Please respect my privacy. Do not forward my address to anyone else or
include me in emails sent to multiple recipients. Use BCC.
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
