Your client/server application can access server data by using: 

Remote views 
SQL pass-through 

Remote views provide the most common and easiest method for accessing and updating remote data. The upsizing wizards can automatically create remote views in your database as part of upsizing, or you can use Visual FoxPro to create remote views after upsizing. For more information on remote views, see Creating Views.

SQL pass-through technology enables you to send SQL statements directly to a server. SQL pass-through statements, because they execute on the back-end server, are powerful ways to enhance the performance of your client/server applications. The following table compares remote views with SQL pass-through.

Check help for 

Comparison of Remote View and SQL Pass-Through Technologies


SQL pass-through technology offers the following advantages over remote views: 

You can use server-specific functionality, such as stored procedures and server-based intrinsic functions. 
You can use extensions to SQL supported by the server, as well as data-definition, server administration, and security commands. 
You have more control over SQL pass-through Update, Delete, and Insert statements. 
You have more control over remote transactions. 
Tip   Visual FoxPro can handle SQL pass-through queries that return more than a single result set.
SQL pass-through queries also have disadvantages: 

By default, a SQL pass-through query always returns a non-updatable snapshot of remote data, which is stored in an active view cursor. You can make the cursor updatable by setting properties with the CURSORSETPROP( ) function. An updateable remote view, in contrast, usually doesn't require that you set properties before you can update remote data, because property settings are stored in the database with the view definition. 
You must enter SQL commands directly into the Command window or into a program, rather than using the graphical View Designer. 
You create and manage the connection to the data source. 
Whether you use remote views or SQL pass-through, you can query and update remote data. In many applications, you'll use both remote views and SQL pass-through.

Aashish

>Hi,
>I am new on developing client server application using VFP. I would like to know, when to use SPT, remote view and stored procedure for the right way.
>
>Pls advice.
>
>Thank you