PROPERTY:  DataControl::ExecuteOptions
adcExecuteOptionEnum = datacontrolobject.ExecuteOptions
datacontrolobject.ExecuteOptions = adcExecuteOptionEnum

The ExecuteOptions property sets or returns one of the adcExecuteOptionEnum constants that specifies whether the execution of a query will be asynchronous or synchronous.

An asynchronous execution returns control to the calling program as soon as the query has been sent to the data server. A synchronous execution does not return control until the query action is completed.

You can use the FetchOptions property to specify exactly when control will be returned to the calling program for an asynchronous fetch.

adcExecuteOptionEnum Constants
Constant Value Description
adcExecAsync 2 Default, executes asynchronously
adcExecSync 1 Executes synchronously

 
You can create a form on a Web page to input values for the various DataControl properties and use Request.Form( ) to assign the values:

Code (VBScript):
objDC.ExecuteOptions = Request.Form("ExecuteOptions")
objDC.FetchOptions = Request.Form("FetchOptions")
objDC.InternetTimeout = Request.Form("InternetTimeout")
objDC.Server = Request.Form("Server.Value")
objDC.SourceRecordset = Request.Form("SourceRecordset")
objDC.SQL = Request.Form("SQL")
objDC.URL = Request.Form("URL")
objDC.Connect = Request.Form("Connect")
objDC.Refresh
Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information