View Complete Thread | FoxWeb Forum Home
Search:
Date:    Msg ID:   
From:    Thread:   
Subject:   
Good idea, but I would not put this in a script, because it will be executed whenever the script is executed.  A better solution is to schedule a batch file that deletes tmp files.

FoxWeb Support Team
support@foxweb.com

Sent by Curtis Hertwig on 11/16/2001 08:15:59 AM:
Alan,

My favorite way to deal with the TMP files is to put this line of code in my main program:

ERASE (ADDBS(SYS(2023)) + *.TMP)

The ERASE command will ignore any files that are still being held open and delete the rest.

   -cjh

Sent by Alan Harris-Reid on 11/15/2001 03:09:21 PM:
When I create a non-filtered cursor in a .fwx script file, a .tmp file is created in the VFP temporary folder, but when the script has finished running, the .tmp file still remains, even though I have the 'Close tables' option checked in the Foxweb configuration page.  Could it be possible that tables are closed but not cursors?  Is this by design?  Usually if a CLOSE DATA ALL command is issued, all cursors are also closed, thus automatically deleting the associated .tmp files.

I have discovered, however, that if I close Foxweb the .tmp files are deleted.  This is not satisfactory since (ideally) Foxweb is running permanently on the server, and I do not want the temporary folder being littered with 'old' .tmp files relating to cursors which were created weeks ago!

Any help/comments on this matter would be appreciated.

Alan