Cursor Auto Fetch Property

ADO and SQL Server

ADO and SQL Server

Cursor Auto Fetch Property

The Cursor Auto Fetch property specifies whether the initial result set is returned when a cursor is opened.

Applies To
Command Object
Syntax

object.Properties("Cursor Auto Fetch") [= value]

Parts

object

Expression that evaluates to an object in the Applies To list.

value

Boolean that indicates when the initial result set is returned as specified in Settings.

Settings
Value Description
True When a cursor is opened, the initial result set is returned.
False Default. When a cursor is opened, no results are returned.

Data Type

adBoolean

Modifiable

Read/write

OLE DB Property

SSPROP_CURSORAUTOFETCH

Remarks

Setting Cursor Auto Open to True can result in a performance enhancement by avoiding an extra round trip to the server.