ADO » Connection » CursorLocation

Syntax:
long = connectionobject.CursorLocation
connectionobject.CursorLocation = long

Sets or returns a long value used to select between various cursor libraries accessible through the provider.

The CursorLocation property establishes the cursor location and services. It sets or returns a long value that is one of the CursorLocationEnum constants. The default is adUseServer, or 2. Server-side and client-side provided cursor services usually add increased flexibility.
 
CursorLocationEnum Constants
 

Constant Value Description
adUseClient 3 Uses a client-side cursor provided by the local library
adUseClientBatch 3 Obsolete
adUseNone 1 Obsolete
adUseServer 2 Uses a server-side cursor provided by the local library

Examples

Code:
objConnection.CursorLocation = adUseServer

See Also: