ADO: ActiveX Data Objects

Name

CursorTypeEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

The CursorTypeEnum enumeration indicates the type of cursor to be used with the Recordset object.

Table E-15. The CursorTypeEnum Enumeration

Enumeration (ADO/WFC)	Value	Description
adOpenDynamic (DYNAMIC)	2	Indicates a dynamic cursor for the recordset. The recordset allows the application to see new records, edited records, and deletions by other users.
adOpenForwardOnly (FORWARDONLY)	0	Default. Indicates a forward-only cursor for the recordset. The recordset does not report added, edited, or deleted records by other users. Think of this cursor as a snapshot of the recordset. This is the fastest type of cursor and is the default setting.
adOpenKeyset (KEYSET)	1	Indicates a keyset cursor for the recordset. The recordset allows the application to see changes in records made by other users. It also denies access to deleted records, but it does not allow you to see records that have been added by other users.
adOpenStatic (STATIC)	3	Indicates a static cursor for the recordset. The recordset does not allow the application to see any changes in the recordset at all. This cursor is only surpassed in speed only by the forward-only cursor.

ADO/WFC

The CursorTypeEnum enumeration is part of the com.ms.wfc.data package, and the constant values are preceded with AdoEnums.CursorType.

See Also

Recordset.CursorType Property, Recordset.Open Method