THE WORLD'S LARGEST WEB DEVELOPER SITE
HTMLCSSJAVASCRIPTSQLPHPBOOTSTRAPJQUERYANGULARXML
 

ADO Cancel Method


Recordset Object Reference Complete Recordset Object Reference

The Cancel method cancels an execution of a method call.

The Cancel method cancels different tasks for each object. The table below shows what task is cancelled when this method is called:

Object Cancelled task
Command Execute.

Note: The Options parameter of the Execute method must be set to adAsyncExecute or adAsyncFetch, before the Cancel method is called, otherwise a run-time error will occur

Connection Execute or Open.

Note: The Options parameter of the Open method must be set to adSyncConnect, or the Options parameter of the Execute method be set to adAsyncExecute or adAsyncFetch, before the Cancel method is called, otherwise a run-time error will occur

Record CopyRecord, DeleteRecord, MoveRecord, or Open

Note: The Options parameter of the Execute method must be set to adAsyncExecute or adAsyncFetch, before the Cancel method is called, otherwise a run-time error will occur

Recordset Open
Stream Open

Syntax

object.Cancel

Recordset Object Reference Complete Recordset Object Reference