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.