Use DELETE FILE when you want to delete any file and free VFP table.
If your want to delete table from VFP DBC you must use DROP TABLE. In this case DROP TABLE removes a table from the current database and deletes it from disk.


>hi,
>thank you so much, it works.
>
>if you have a time what the different between delete and drop.in this case
>
>>>hi all,
>>>
>>>is there away to drop free table if found
>>>as
>>>

>>>locate for aa.dbf
>>> if found()
>>>   drop table aa
>>>else
>>>  mesagebox("not found")
>>>endif
>>>

>>>thanks
>>
>>

>>m.PathToFile = "c:\yourdir\"
>>lcSearchFile = m.PathToFile+"aa.dbf" &&& example lcSearchFile = c:\yourdir\aa.dbf
>>IF FILE(m.lcSearchFile)
>>   DELETE FILE(m.lcSearchFile)
>>ELSE
>>   MESSAGEBOX("Not Found")
>>ENDIF
>>