| title | ExecuteOptions Property (RDS) | Microsoft Docs | |
|---|---|---|
| ms.prod | sql | |
| ms.prod_service | connectivity | |
| ms.technology | connectivity | |
| ms.custom | ||
| ms.date | 01/19/2017 | |
| ms.reviewer | ||
| ms.topic | conceptual | |
| apitype | COM | |
| helpviewer_keywords |
|
|
| ms.assetid | 62a4fd88-afc3-4f1f-b978-40710a30c4e9 | |
| author | MightyPen | |
| ms.author | genemi |
Indicates whether asynchronous execution is enabled.
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.
| Constant | Description |
|---|---|
| adcExecSync | Executes the next refresh of the Recordset synchronously. |
| adcExecAsync | Default. Executes the next refresh of the Recordset asynchronously. |
Note
Each executable file that uses these constants must provide declarations for them. You can cut and paste the constant declarations that you want from the file Adcvbs.inc, located in the default installation folder for the RDS library.
If ExecuteOptions is set to adcExecAsync, then this asynchronously executes the next Refresh call on the RDS.DataControl object's Recordset.
If you try to call Reset, Refresh, SubmitChanges, CancelUpdate, or Recordset while another asynchronous operation that might change the RDS.DataControl object's Recordset is executing, an error occurs.
If an error occurs during an asynchronous operation, the RDS.DataControl object's ReadyState value changes from adcReadyStateLoaded to adcReadyStateComplete, and the Recordset property value remains Nothing.
ExecuteOptions and FetchOptions Properties Example (VBScript)
Cancel Method (RDS)