CursorLocation Property - ADO

Sets or returns the location of the cursor engine.

Applies To

Connection, Recordset

Required Files

msado15.dll
VC: adoint.h, adoid.h

Settings And Return Values

The setting or return value is a Long that can be set to one of the following constants:

Constant Description
adUseNone No cursor library is used
adUseClient or adUseClientBatch (Default) Uses client-side cursors supplied by a local cursor library. Local cursor engines will often allow many features that driver-supplied cursors may not, so using this setting may provide an advantage with respect to features that will be enabled.
adUseServer Uses data provider or driver-supplied cursors. These cursors are sometimes very flexible and allow for some additional sensitivity to reflecting changes that others make to the actual data source. However, some features of the Microsoft Client Cursor Provider (such as disassociatable recordsets) cannot be simulated with server-side cursors and these features will then become unavailable with this setting.
<provider-defined>

Remarks

This property allows you to choose between using various cursor libraries accessible to the provider. Normally, the choice is between using a client-side cursor library or one that is located on the server, although providers can add other options by supporting other constants.

This property setting only affects connections established after the property has been set. Changing the CursorLocation property has no effect on existing connections.

This property is usually read/write while the connection is closed and becomes read-only once the connection is opened. Some providers may also allow this property setting to change while the connection is open (i.e., it remains read/write all the time).

Note To use batch updating, you should set the CursorType property to either adOpenKeyset or adOpenStatic, set the LockType property to adLockBatchOptimistic, and set the CursorLocation property to adUseClient (or its synonym adUseClientBatch) to enable the Microsoft Client Cursor Engine, which is required for batch udates.

Examples

CursorLocation Property Example (VB)

See Also

ADO Providers


© 1997 Microsoft Corporation. All rights reserved. Terms of Use.