ADO WillExecute 和 ExecuteComplete 事件
定义和用法
事件是某个具体的操作发生后被自动调用的子例程。
- WillExecute 事件在调用 objcomm.Execute, objconn.Execute 或者 objrs.Open 之前会被触发
- ExecuteComplete 事件会在完成对 objcomm.Execute, objconn.Execute, objrs.Open, objrs.Requery 或 objrs.NextRecordset 的调用之后被触发
语法
WillExecute src,cursortyp,locktyp,options,status,objcomm,objrs,objconn ExecuteComplete recaffected,objerror,status,objcomm,objrs,objconn
| 参数 | Maelezo |
|---|---|
| src | 字符串，包含 SQL 命令或存储过程名称。 |
| cursortyp | 规定要使用的游标类型。CursorTypeEnum 值之一。 |
| locktyp | 规定要使用的锁定类型。LockTypeEnum 值之一。 |
| options | 一个或多个 CommandTypeEnum 或 ExecuteOptionEnum Value |
| recaffected | Long 值，该命令影响的记录的数目。 |
| objerror |
包含已发生的错误的 Error 对象。
Kweli: Kina. EventStatusEnum kinahitajika kuwa adStatusErrorsOccurred, kumueleza kina hii Error. |
| status | Kina. EventStatusEnum Kina. |
| objcomm |
Kwa WillExecute: Ikiwa hii matukio inatokana na Command.Execute, kipakuo cha objcomm kinasababisha Command kina, kipakuo cha objrs kinasababisha kuwa kwa jinsi ya kumekadiri. Kwa ExecuteComplete: Kipendelea kufanya Command kina. |
| objrs |
Kwa WillExecute: Ikiwa huu shindano inadaiwa na Recordset.Open, maelezo wa objrs inatokana na Recordset object, pCommand inasababishwa kwa Nothing. Kwa ExecuteComplete: Recordset object, ni matokeo wa kumfanyia kikomenda. |
| objconn | Connection object ambao anahusishwa na kumfanyia kikomenda. |
Adhara ya EventStatusEnum
| Makadara | Value | Maelezo |
|---|---|---|
| adStatusOK | 1 | Shughuli ambayo inadai shindano inafaiwa kusababisha shindano. |
| adStatusErrorsOccurred | 2 | Shughuli ambayo inadai shindano inafaiwa kusababisha shindano. |
| adStatusCantDeny | 3 | Haiwezi kusasisha shughuli ambayo inahusishwa. |
| adStatusCancel | 4 | Inaruhusiwa shughuli ambayo inadai shindano. |
| adStatusUnwantedEvent | 5 | Inaruhusiwa ujumbe wa kufuata kabla ya kumaliza matukio ya kifungu. |
