Ok CA = Cursor Adapter, but why it is better ?

>Excuse me, but what do you mean for CA ? and why is it better for you ?
>
>>>>>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 it 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 change 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
>>>>
>>>>What you use to get data ffrom SQL Server?
>>>>CA or SPT?
>>>
>>>I think to use SPT.
>>
>>Your choice, but that way you are stick to ODBC.
>>The later versions of SQL Server ODBC drivers (Native Client 2005, 2008) have some issues when you use them in VFP.
>>But as James already said, you should start think for recordsets not for Tables.
>>You never need the WHOLE bunch of records from entire table, you rarely need more than 1000 records at a time from a huge table (there is NO WAY to user to manipulate several billions of records, isn't it?). So indexing 10000 records is not a big deal :-)