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,