1. You could use a cursor instead 2. you could try "delete file (fname)" 3. you could try "run delete &fname" 4. Try an explicit pathname in the filename 5. try "run delete tmp*"
What you're doing looks like it should work. If seen the command not work before and not give any error message, but I don't know why. --- "John J. Mihaljevic" <[EMAIL PROTECTED]> wrote: > 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. > _______________________________________________ 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.
