>Can you tell me how to use the sys(2015) to name my index. I am haveing trouble with it.
You have to store it to a variable. Something like this (not tested):
local lcIndexName
lcIndexName = sys(2015)
use MyView
index on MyField to (lcIndexName)
...
...
use in MyView
erase (lcIndexName + ".idx")
But consider Sergey's note about using CDX - that should be simpler.
You may still require the above technique for some other temporary files.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)