Sorry, I meant to write erase temp.idx

>Hi Larry,
>
>I guess that since you use anytable again, you may have antable open in another work area, and that you must also close anytable in that area. What about this
>

>set index to
>use
>erase temp.dbf
>

>
>
>>Here's a head-scratcher...
>>
>>set excl off
>>use anytable
>>cursorsetprop('buffering',5)
>>
>>o=createobject('session')
>>set datasession to o.datasessionid
>>use anytable again
>>index on anyfield to temp.idx
>>
>>after working with the table in the private data session I want to delete the temp.idx file.
>>
>>use
>>erase temp.idx
>>
>>If I close the table in o then try to delete the index file, it says that the file is in use. When I go back to the first session, sure enough, temp.idx has been set there as an active index.
>>
>>In o, then tried to issue
>>
>>SET INDEX TO
>>use
>>erase temp.idx
>>
>>Now with the buffering set in the first datasession the "set index to" statement does not work.
>>
>>Any ideas on how to do this without referring back to the first datasession?
>>
>>TIA,