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: