The Cursor Auto Fetch property specifies whether the initial result set is returned when a cursor is opened.
object.Properties("Cursor Auto Fetch") [= value]
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.
| 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. |
adBoolean
Read/write
SSPROP_CURSORAUTOFETCH
Setting Cursor Auto Open to True can result in a performance enhancement by avoiding an extra round trip to the server.