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.