>>>>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.
I'm sure you wouldn't bet on I could index all fields (that'd make multiple indexes) :)
Actually even in fox2x you could do that (no READWRITE... clause). All you need is to create a true cursor and use again.
Cetin