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.