>How to change a views order settings programmaticly?
>Thanks.

1. You can create view programaticly but that is many rows of code. If You are using VFP 8 you can view how to create view in view designer.

2. Just index your view before requery:

   USE MyView NODATA
   ** IF You put the view in DE just set NoDataOnLoad
   
   INDEX ON MyFirstField TAG MyView
   INDEX ON MySecField   Tag MyView1
   ...
   REQUERY("MyView")

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.