| title | ReadyState Property (RDS) | Microsoft Docs | |
|---|---|---|
| ms.technology | connectivity | |
| ms.custom | ||
| ms.date | 01/19/2017 | |
| ms.reviewer | ||
| ms.prod | sql | |
| ms.prod_service | connectivity | |
| ms.topic | conceptual | |
| apitype | COM | |
| helpviewer_keywords |
|
|
| ms.assetid | 5be75bc7-1171-4440-a37e-c8cc6b5cd865 | |
| author | MightyPen | |
| ms.author | genemi |
Indicates the progress of a DataControl object as it retrieves data into its Recordset object.
Important
Beginning with Windows 8 and Windows Server 2012, RDS server components are no longer included in the Windows operating system (see Windows 8 and Windows Server 2012 Compatibility Cookbook for more detail). RDS client components 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.
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 default installation folder for the RDS library.
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.
ReadyState Property Example (VBScript)
Cancel Method (RDS)
ExecuteOptions Property (RDS)