ADO CursorLocation Property
The CursorLocation property sets or returns a long value that indicates the
location of the cursor service. It can be set to one of the CursorLocationEnum
values.
Default value is AdUseServer.
A cursor is used to:
- control record navigation
- control the visibility of changes in the database
- control the updatability of data
Note: A Recordset object inherits this setting from the associated
Connection object.
Note: This property is read-only on an open Recordset object, and
read/write on a Connection object or on a closed Recordset object.
Syntax
objConnection.CursorLocation
objRecordset.CursorLocation
|
Example
Dim
conn As ADODB.Connection
Dim recSet As ADODB.Recordset
Dim sql As String
Set conn = New ADODB.Connection
conn.Provider = "Microsoft.Jet.OLEDB.4.0"
conn.Open "Data Source=f:\MaterialMaster\Material_Master.mdb"
Set recSet = New ADODB.Recordset
sql = "SELECT * FROM tblAMSEA WHERE LocationID ='8800'"
recSet.CursorLocation = adUseClient
recSet.CursorType = adOpenStatic
recSet.LockType = adLockBatchOptimistic
recSet.Open sql, conn
rs.Close
conn.Close |
CursorLocationEnum Values
| Constant |
Value |
Description |
| adUseNone |
1 |
OBSOLETE (appears only for backward compatibility). Does not use
cursor services. |
| adUseServer |
2 |
Default. Uses a server-side cursor. |
| adUseClient |
3 |
Uses a client-side cursor supplied by a local cursor library. |
| adUseClientBatch |
3 |
For backward compatibility, the synonym adUseClientBatch is also
supported. |
|