ReadyState Property (RDS)

See Also   Example   Applies To   

Reflects the progress of an RDS.DataControl object as it fetches data into its Recordset object.

Settings

The ReadyState property can have one of the following values.

Value Description
adcReadyStateLoaded The current query is still executing and no rows have been fetched. The RDS.DataControl object's Recordset is not available for use.
adcReadyStateInteractive An initial set of rows retrieved by the current query have been stored in the RDS.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 RDS.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.

Remarks

Use the onReadyStateChange event method to monitor changes in the ReadyStateChange 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.