>>>>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.
>Never use SELECT * FROM ....
>Always use SELECT Field1, Field2....
>That way you get only this information you need at a time.
>NEVER use SELECT w/o WHERE clause (of course that is valid only for HUGE tables, tables with 10 recs are exclusion from this rule :-))
>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 :-)


To connect to SQL Server which ca.DataSourceType do you suggest ?