ADO » Recordset » CursorLocation
- Syntax:
- CursorLocationEnum = recordsetobject.CursorLocation
recordsetobject.CursorLocation = CursorLocationEnum
Sets or returns a long value that is a CursorLocationEnum value which defines the location of the cursor engine (server-side or client-side).
The CursorLocation property sets or returns one of the CursorLocationEnum
constants that specifies the location of the cursor library.
In reality, there are only two choices, client-side or server-side.
Typically, client-side cursors are more versatile.
However, the default is to the server-side.
You cannot change the cursor library for a Recordset while it is open.
CursorLocationEnum Constants
| Constant | Value | Description |
| adUseClient | 3 | Use client-side cursor supplied by the local cursor library |
| adUseClientBatch | 3 | Obsolete, same as adUseClient |
| adUseNone | 1 | Obsolete, no cursor service |
| adUseServer | 2 | Default, use the cursor supplied by provider or database |
Examples
Code:
Set objRecordset = Server.CreateObject("ADODB.Recordset")
Set objRecordset.ActiveConnection = strConnection
objRecordset.CursorLocation = adUseClient
objRecordset.CursorType = adOpenDynamic
...
objRecordset.Open "ChantList", , , , adCmdTable
See Also:
