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,