ADO vs. Remote Views and which is best for C/S development in VFP...

First, it is important to discuss what Remote Views are. Remote views are nothing more than an INCOMPLETE wrapper around SQL Pass Through. MS made an attempt to "dumb-down" SPT by creating the Remote View Feature.

Remote Views have several problems. The three biggest issues are:

1. You cannot use SQL Stored Procedures
2. Schema changes cause your Remote Views to break
3. Data logic is tightly coupled with UI

While Remote Views are bad, the underlying technology is good - that being SQL Pass Through.

As for ADO, that is an excellent technology as well.

In VFP, believe it or not, a combination of ADO and SQL Pass Through is best. ADO - because of its powerful Command Object. SPT - because you can render child data in memory-based VFP cursors.

Take my advice, go to http://www.takenote.com/dc2000.htm and check out DataClas 2000. It is the BEST data framework for working with SQL Server in Visual FoxPro.

Best...



>I want to know which of the above two techniques are best suited for
>the client server application using VFP and SQL Server.