Using SQL Pass-Through Technology

Using remote views is the easiest and most common method to access and update remote data. SQL pass-through technology allows you to send SQL statements directly to the server and, because the statements execute on the server, they are a powerful way to enhance the performance of your client/server application.

The following topics provide information on how to use SQL pass-through technology in your applications.

In This Section

• How to: Access Stored Procedures on Remote Servers with SQL Pass-Through Functions
  Describes how to use server stored procedures. Server stored procedures can greatly enhance performance of SQL statements and batches.

• How to: Use SQL Pass-Through Functions
  Explains how your client/server application can access remote data with SQL pass-through. A comparison of remote views and SQL pass-through technologies is also provided.

• Visual FoxPro SQL Pass-Through Functions
  Provides a list of SQL Pass-Through functions.

• Using Result Sets
  Explains how Visual FoxPro handles result sets that are returned from SQL Pass-Through functions.

• How to: Return Multiple Result Sets
  Explains how to retrieve multiple result sets, such as those from a stored procedure that contains native server SELECT statements.

• How to: Create a Parameterized Query
  Explains how to create a parameterized query with SQL pass-through technology.

• Using SQL Server Input/Output Parameters
  Describes how to use input and output parameters to pass values between SQL Server and Visual FoxPro.

• Execution of ODBC Extensions to SQL
  Provides information on how to execute OBDC extensions to SQL.

• Managing Connections with SQL Pass-Through
  Describes how to manage your server connections by providing an overview of the various environment and connection properties and how to set them.

• Sharing Connections for Remote Data
  Describes how Visual FoxPro makes it possible for you to share a connection handle for a remote data connection, which is useful for reducing the number of connections when managing SQL Server connections and server resources.

• How to: Use Automatic Transaction Mode
  Describes how to set Visual FoxPro to automatically wrap every data-writing operation sent to a remote server in a transaction.

• How to: Control Transactions Manually
  Describes how to manually control transactions with a remote server.

• Selecting the Right Methods
  Describes and contrasts the best practices for use of remote views and SQL pass-through technology in your client/server application.

Related Sections

• Working with Remote Data Using SQL Pass-Through
  Explains how you can view and control the properties of a SQL pass-through query result set cursor using the Microsoft Visual FoxPro functions CURSORGETPROP( ) and CURSORSETPROP( ).

• Working with Data
  Describes how to create effective applications with indexes, tables, and databases based on your data requirements.

• Handling SQL Pass-Through Errors
  Explains how to retrieve information about the error to examine the error and to determine its cause.