>>>
>>>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.
i have only seen that where the user turns off the machine in the middle of processing. when that happens, an extra cdx/idx file floating around is usually the least of my problems.