We are converting our application from fully VFP to Vfp as frontend and Sql server as database. Now we have grids with fox data and when we click on column header we change order of data in grid; with Vfp iit is easy we "set order to...." and the grid refreshes data without problem. How it works if the database is SQL server. Once i have opened a form where user can enter filter parameter to select which data to put in my grid and when i have filled my grid with a remote view or with SQLExec() function how can i change order of data in the grid ? I have to chnage grid object and use one like dbitech controls where grid is an object and where the column order is inside the control ? or is there a way with vfp grid ?

Thanks