>>>To avoid problems with multi-user access, a temporary index should not have a fixed name. Assign sys(2015) to a variable, create the index with that name, and delete it later.
>>>
>>>Hilmar.
>>
>>Yes we use a tempname function with the random generator function to ensure unique(well close to unique) idx name.
>>
>>Einar
>
>Another thing is that such temporary indexes may be created on the user's local drive instead of application directory on the network. That simplifies the uniqueness problem - SYS(2015) is enough - and kind of speeds up the indexing. Also, the application on quitting may just wipe out all temporary indexes on local temp directory at once.
Nick, the .IDX file is temporary only in that you don't need it any more. You still have to clean it up yourself. The only temporary index file would be a .CDX created on a cursor, that would delete itself when you close the cursor.