Hi Martin,
This will work, but it is not so efficient, and you must be sure to delete the indexfiles after they are not needed anymore.
INDEX ON yourfield TAG yourfield
will create the index in RAM if possible, and it will be deleted automatically when the cursor is released.
>Hi Antonio,
>
>You can create index on localmachine:
>
>*INDEX ON eExpression TO IDXFileName | TAG TagName [OF CDXFileName]
>* [FOR lExpression] [COMPACT] [ASCENDING | DESCENDING]
>* [UNIQUE | CANDIDATE] [ADDITIVE]
>
>INDEX ON bla TAG blaI OF c:\temp\bla.cdx
>
>
>MartinJ
>
>>I have a form where I use create cursor to create a temporary table. This temporary table is indexed with comand INDEX ON ... ADDITIVE
>>
>>The problem is: when this form is been used by two or more users at same time I receive a message asking to overwrite the index.
>>
>>How to solve this?
>>
>>I am using VFP7 and the session is defined as private.