ADODB Object

CursorLocation

 
Syntax
 
long = connectionobject.CursorLocation
connectionobject.CursorLocation = long
 
Description
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
See Also
Command, Connection, Execute, Recordset.
Example
 
objConnection.CursorLocation = adUseServer