>>>I have a grid based on a view (Optimistic table buffering)
>>>
>>>How can I change the sort order of the view programmaticaly?
>>>
>>>The view as a sort condition in it, but I want to change it at run time. I tried to create an index, but VFP refuse to create an index on a table buffered view.
>>
>>Select View1
>>=cursorsetprop("buffering",3)
>>Index on ... tag ...
>>=cursorsetprop("buffering",5)
>>*** and go ahead
>
>If I have uncommited modifications to the view, won't changing the view buffering commit these modifications?
Index view before your have made any modifications, e.g.in Form.Init event.
Edward Pikman
Independent Consultant