>>Is there any way I can have the inedx tags defined on a table added to the cursor created with a select SQL statement.
>>
>>eg. Select * from Mytable where fieldA='123' into cursor MyCursor
>>
>>if fieldA is indexed, can I make the fieldA in MyCursor indexed too?
>>
>>Thanks.
>>
>>Ria
>
>Select....into cursor...
>index on (field_name) tag (tag_name)
>
>If you need more than one index, then you need to do the trick:
>Select....into cursor My2Cursor
>use (dbf("My2Cursor")) again in 0 alias mycursor
>sele mycursor
>index on....
>index on...

In VFP7 you don't have to do that anymore.

Select....into cursor...READWRITE
index on....
index on...

IN VFP6 and earlier add NOFILTER clause to make sure that cursor is created not as filtered source table

Select....into cursor...NOFILTER