Cursor Auto Fetch Property
From 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.