Quick Restart Property
The Quick Restart property specifies whether the command that created a recordset must be reexecuted before the MoveFirst method is executed.
Applies To
| Command Object | Recordset Object |
Syntax
object.Properties("Quick Restart") [= value]
Parts
object
Expression that evaluates to an object in the Applies To list.
value
Boolean that indicates whether the command that created a recordset must be reexecuted, as specified in Settings.
Settings
| Value | Description |
|---|---|
| True | The MoveFirst method is relatively quick to execute. In particular, it does not reexecute the command that created the recordset. |
| False | The MoveFirst method is expensive to execute and requires reexecuting the command that created the recordset. |
Data Type
adBoolean
Modifiable
Read/write
OLE DB Property
DBPROP_QUICKRESTART
Remarks
Although the value of this property can be set to True, the provider is not required to honor it. The reason for this is that the provider does not know what the command is at the time the property is set. For example, the application can set this property and then change the command text. However, the provider can fail the Quick Restart property if it is never able to quickly restart the next fetch position. Therefore, if an application successfully sets the Quick Restart property, it must still check this flag on the recordset to determine if the next fetch position can be quickly set.