ADO BeginTransComplete, CommitTransComplete, and RollbackTransComplete events
Definition and Usage
Events are subroutine calls that are automatically invoked after a specific operation is performed.
- The BeginTransComplete event is triggered after the BeginTrans call is completed.
- The CommitTransComplete event is triggered after the CommitTrans call is completed.
- The RollbackTransComplete event is triggered after the RollbackTrans call is completed.
syntax
BeginTransComplete translevel,objerror,status,objconn CommitTransComplete objerror,status,objconn RollbackTransComplete objerror,status,objconn
| parameter | Description |
|---|---|
| translevel | Long value, containing the new transaction level of the BeginTrans that triggered this event. |
| objerror |
The Error Object that contains the errors that occurred. Note:EventStatusEnum The value must be set to adStatusErrorsOccurred to create an Error Object. |
| status | Specify the status of the event execution. Take EventStatusEnum Status Value. |
| objconn | The Connection Object that triggered this event. |
EventStatusEnum Value
| Constant | Value | Description |
|---|---|---|
| adStatusOK | 1 | The operation that triggered this event was successful. |
| adStatusErrorsOccurred | 2 | The operation that triggered this event failed. |
| adStatusCantDeny | 3 | Cannot cancel suspended operations. |
| adStatusCancel | 4 | Cancel the operation that caused the event. |
| adStatusUnwantedEvent | 5 | Prevent subsequent notifications before the event method execution is completed. |
