Working with Remote Data Using SQL Pass-Through

After you retrieve a result set using SQL pass-through, you can view and control the properties of your result set cursor using the Visual FoxPro functions CURSORGETPROP( ) and CURSORSETPROP( ). These are the same functions you use to set properties on an active view cursor.

Note

Cursors are not objects and thus are not tied to the object model. However, you can view their properties, or attributes, with CURSORGETPROP() and set their properties with CURSORSETPROP().

In This Section

• Setting Cursor Properties for Remote Data
  Describes the purpose of the remote data cursor properties and how to set them using SQL pass-through and the Remote Data tab of the Options dialog box.

• How to: Update Remote Data with SQL Pass-Through
  Describes how to update remote data including specific details about the updates, such as controlling the timing of remote updates, using optimistic row and table buffering, detecting changes by other users, forcing updates, and how to troubleshoot update error messages.

• Selecting an Efficient SQL Pass-Through Processing Mode
  Compares and contrasts the two types of processing modes for retrieving and updating remote data using SQL pass-through: synchronous and asynchronous.

• How to: Use SQL Pass-Through Asynchronously
  Explains how to set your client/server application to use asynchronous processing for SQL pass-through.

• Processing Multiple Result Sets
  Describes how to process multiple result sets using synchronous or asynchronous batch mode and non-batch mode processing.

• Data Type Conversion Control
  Explains how data types are mapped between OBDC or ADO and Visual FoxPro so you can predict how a remote server's data will be treated by your Visual FoxPro application.

Related Sections

• Enhancing Applications Using SQL Pass-Through Technology
  Explains how your application can make use of SQL pass-through technology to access remote data, run stored server procedures, execute commands using native server syntax, and create objects on the server.

• How to: Set Up an ODBC Data Source
  Describes how to install an OBDC driver so you can use an OBDC data source with remote views and SQL pass-through.

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