>>>I have a grid which is populated from a cursor. I have an option group in which I want to change the sort order of the records in the grid. Do I have to run the query again and change the order by statement and then refresh the grid or can I change the order without doing this?
>>>
>>>Many Thanks
>>
>>What kind of cursor it is? If this is a result of select statement from native VFP database, you need to add READWRITE option to your select code. Then you would be able to index it on the fly.
>>
>>If this is a different kind of cursor, you need to have a separate cursor for your grid created with CREATE CURSOR command. This cursor allows you to index it.
>
>Naomi,
>I don't know of a cursor type that I can't index.
>Cetin

Well, if this is SELECT .. from NATIVETable into cursor ... NOFILTER
you would be able to index only once.

I'm not sure about SPT cursors either.