>>>I need to add an index tag to a cursor (cursor created with SQL Select). So far, the only way I can do it is by making the cursor READWRITE (in SQL Select).
>>>
>>>Or by creating index not as a tag but as a standalone index (.idx). The nice thing about cursor is that I don't have to clean it up, that is, VFP erases the file or somehow it is being cleaned. What about Standalone index on a cursor? Do I need to do anything for it or the index is also stored in a temp folder and gets cleaned up?
>>
>>Dmitry,
>>
>>I believe you can add one (and only one) index tag to a non-READWRITE select cursor. Vfp cleans the cdx when the cursor closes
>
>Gregory,
>
>Maybe I am missing something but I tried to add an index tag to a readonly cursor and get an error that cursor is ready only. Here is an example of how I did it:
>
>

>select * from mytable into cursor cur_mytable
>select cur_mytable
>index on myfield tag mytag
>*-- ERROR: cursor is readonly.
>

>
>You see anything I could be doing differently?
>
>Thank you.

Now, that is strange

select * from personnel into cursor pp
index on emp_id tag pp && ok
index on emp_id tag hh  && error: file ......tmp is readonly

I actually see the cdx in my tmp directory until the cursor closes

Maybe add: NOFILTER ??