ADO Cancel 方法

 

The Cancel method cancels an execution of a method call.
Cancel的作用是：取消执行一个方法请求。

The Cancel method cancels different tasks for each object. The table below shows what task is cancelled when this method is called:
Cancel将根据每个对象取消执行不同的任务。下表列举了这些被取消的任务：

Object 对象	Cancelled task 被取消的任务
Command	Execute. 执行[Excute] 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 注意：执行[Excute]方法中的Option[选项]参数选项必须在请求Cancel[取消]方法之前设置为adAsyncExecute 或adAsyncFetch，否将将产生一个运行时间[run-time]上的错误
Connection	Execute or Open. 执行或打开[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 注意：在请求Cancel[取消]方法之前，Open[打开]方法中的选项参数必须设置为adSyncConnect，或者Execute方法中Option参数必须设置为adAsyncExecute 或 adAsyncFetch，否将将产生一个运行时间[run-time]上的错误
Record	CopyRecord, DeleteRecord, MoveRecord, or Open 复制记录、删除记录、移动记录或打开[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 注意：在请求Cancel[取消]方法之前，Execute[执行]方法中Option[选项]参数必须设置为adAsyncExecute 或 adAsyncFetch，否将将产生一个运行时间[run-time]上的错误
Recordset	Open 打开
Stream	Open 打开

Syntax
语法

object.Cancel