>>>>If I do
>>>> INDEX ON view TAG view_tag
>>>>
>>>>DO I need to explicitly delete the index file OR
>>>>the system will delete it automatically?
>>>>
>>>>If I need to do it explicitly How do i know the file name
>>>>if I do not name it in the index command?
>>>>
>>>View indexes are in memory, you don't need to delete them.
>>
>>Just making sure that the syntax you are really using doesn't use the view name in the INDEX ON statement...?
>
>eric is right. just use the cursor when finished and the cursor and its index will be gone.
Usually yes, 99% true, but I really saw that sometimes it didn't disappear and I had to add some routine to check for dbf() name and delete corresponding cdx file. I have some suspicion that it's happened because of VFP habit to decide itself where temp file will be created, on disk or in memory.
Edward Pikman
Independent Consultant