>>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.