Cancel - method of the AdoRecordset object
Description:
The method cancels an execution of a method call (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 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 must be set to adAsyncExecute or adAsyncFetch, before 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 calling Cancel method, otherwise a run-time error will occur. |
Recordset |
Open |
Stream |
Open |
Example:
JavaScriptVBScriptSelect and copy to clipboard
oRs.Cancel();
oRs.Cancel