Hi Jane,

There are few concrete best mechanisms, but some rules of thumb I have found helpful:

Use remote views if......

You're more comfortable working with Fox commands and you don't really want to get too involved with SQL Server commands. Remote views are a great learning tool for client/server and often will get the job done. This is the easiest way to bind controls to data.

Use SPT if......

You are dealing with large data sets, are comfortable with T-SQL, and/or have identity or uniqueidentifier fields defined in the SQL Server database.

Use ADO if.....

If this may be an n-tier solution involving non-VFP and non-SQL Server components. Since you can't directly bind controls to ADO recordsets, then you almost have to design your system similar to the old Fox way of using memvars or arrays for displaying and manipulating data. Then again, there are the VFPCOM functions for CursorToRs and RSToCursor to move data between tables and recordsets that may alleviate the binding issues....

Conclusion:

Use what is comfortable and what you believe represents the best fit with your application architecture.

>We are using SQL Server as Back-end, VFP as Front-End. Which of the above mechanisms is the best one to manipulate data? What mechanism is best suite in a specific case?