Indicates the progress of a DataControl object as it retrieves data into its Recordset object.
Sets or returns one of the following values.
Value | Description |
---|---|
adcReadyStateLoaded | The current query is still executing and no rows have been fetched. The DataControl object's Recordset is not available for use. |
adcReadyStateInteractive | An initial set of rows retrieved by the current query has been stored in the DataControl object's Recordset and are available for use. The remaining rows are still being fetched. |
adcReadyStateComplete | All rows retrieved by the current query have been stored in the DataControl object's Recordset and are available for use.
This state will also exist if an operation aborted due to an error, or if the Recordset object is not initialized. |
Note Each client-side executable file that uses these constants must provide declarations for them. You can cut and paste the constant declarations you want from the file Adcvbs.inc, located in the C:\Program Files\Common Files\System\MSADC folder.
Use the onReadyStateChange event to monitor changes in the ReadyState property during an asynchronous query operation. This is more efficient than periodically checking the value of the property.
If an error occurs during an asynchronous operation, the ReadyState property changes to adcReadyStateComplete, the State property changes from adStateExecuting to adStateClosed, and the Recordset object Value property remains Nothing.
Cancel Method (RDS) | ExecuteOptions Property (RDS)
Applies To: DataControl Object (RDS)