>>I have several programs that uses INDEX ON to create a temp IDX file (based on fields from more than one related table). At the end of the program I want to close the index and delete the file. In FPW2.6 I used to type:
>>
>>CLOSE DATA
>>IF FILE (mtemp)
>> ERASE (mtemp)
>>ENDIF
>>
>>In 6.0 I get an error - File in Use. I tried
>>
>>SET INDEX TO
>>ERASE mtemp
>>
>>and got no error but the file was left on the disk (not deleted) and until I left my application, the file was still in use. I will be rewriting these programs over time, but it is not practical to rewrite them all now. How do I get rid of these things within the prgram like before?
>>
>>
>>Thanks for the help!
>>
>>Sandi Cassidy
>
>
>When you close the table, the index will be closed. You still need to CLOSE DATA.

That worked, thanks!

Sandi