G:\calprod\
is the current working directory and where the EXE is running.
An error "file does not exist" appears on PACK command below. The file exist when the USE is done, but is missing (deleted from disk) on PACK. When I checked in g:\dbase\, MyTable is really not there. But a TMP file has been created in the g:\calprod\. I understand that PACK create a TMP file and command is not completed until VFP rename the TMP to DBF. My question is:
WHAT's WRONG WITH THE PACK? WHAT ARE THE REASONS A PACK FAILED?
SELECT A
USE g:\dbase\MyTable EXCLUSIVE
DELETE FOR id > 10000
PACK