This kind of grids are read-only. I have to test how long is the waiting time if i make an index when the user clicks on the header. I have to make the index only the first time obviously.
The problem is that, if i can understand what means yo pass to data set from native use of dbf, the customers see only the seconds that pass. I have make the idea that in tha conversion from dbf to sql we add more security, but we loose performance in some operations. Is it true ?

>One of the big issues changing from DBFs to SQL Server is learning to think is data sets. You need to reduce the number of records in a cursor. Next, only index the column when the user request it. Indexing 70-80 thousand rows doesn't take the long. When the user clicks on a header, the program first checks if the index exists then either creates it or sets order to. Of course, this will not work if you allow the user to edit data in the grid.
>
>>Yes, i can, but only with cursor with a little number of records. The problem is when i select a great number of records and after i have executed my query a can't make a "index on " for every column i have in grid. My customers now are used to click on the header and immediately see the grid changes order. And the same problem is when i enter the form where i can't make all the index i need in the grid. I think there is another way to use this records. I have tables with 6/700000 records. Ok i can filter them with my form's filter parameter and let the user to restrict data set, but the risk i obtain 80/90000 record is very high and in this case the user has to wait too much time...
>>
>>>You can index the grid's cursor. The only problem is you can't create the index with buffering set to 5.
>>>
>>>>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