ExecuteOptions Property (RDS)

Microsoft ActiveX Data Objects (ADO)

ExecuteOptions Property (RDS)

       

Indicates whether asynchronous execution is enabled.

Settings and Return Values

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 client-side 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 C:\Program Files\Common Files\System\MSADC folder.

Remarks

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.