ADO » DataControl » ReadyState
- Syntax:
- adcReadStateEnum = datacontrolobject.ReadyState
Important-
This feature will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Applications that use RDS should migrate to WCF Data Service.
The ReadyState property is deprecated in ADO.
Sets or returns an adcReadStateEnum value that defines the progress status as a DataControl object retrieves data into a Recordset object.
The ReadyState property returns one of the adcReadyStateEnum constants that indicates the current status of retrieving data from the data source and placing that data into the Recordset object associated with the DataControl object.
You can use the onReadyStateChange event to monitor the progress of the data retrieval.
adcReadyStateEnum Constants
| Constant | Value | Description |
| adcReadyStateComplete | 4 | All data has been retrieved and stored in the Recordset, or an error has aborted the query, or the Recordset is not initialized |
| adcReadyStateInteractive | 3 | Recordset is currently receiving data |
| adcReadyStateLoaded | 2 | The query is executing but no data has been fetched |
If an error occurs during the execution of the query and the operation is aborted, adcReadyStateComplete will be returned by the ReadyState property.
Examples
Code:
If objDataControl.ReadyState = adcReadyStateLoaded Then
MsgBox "Currently Executing Query", vbOK
End If See Also:
