Partager via


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

  • 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.