ADODB Object
 
Syntax
 
connectionobject.Cancel
 
Description
Cancels the execution of a pending Execute or Open call.
 
The Cancel method is used to cancel the last pending, asynchronous call involving either the Execute or the Open methods of the Connection object.
 
This requires that the Options parameter of the Open method be set to the adSyncConnect ADO constant or that the Options parameter of the Execute method be set to either the adAsyncExecute or adAsyncFetch ADO constant. Otherwise, a run-time error will be generated.
 
An asynchronous call returns control to the calling program before the operation is completed and allows the execution of the code to continue.
See Also
Command.Cancel, Execute, Open, Record.Cancel, Recordset.Cancel, Stream.Cancel.
Example
 
objConnection.Cancel