>>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")
Thanks Borislav
I know how to create views programaticly. I want to change the order for a existing view. The view is a remote view. I dont wont to use VFP index'es.