Edytuj

Udostępnij za pośrednictwem

ReadyState property (RDS)

  • Artykuł

Applies to: Access 2013, Office 2013

Indicates the progress of a DataControl object as it retrieves data into its Recordset object.

Settings and return values

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.

Remarks

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.