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,