ADO Connection and Recordset Events
Two ADO objects can raise events: the Connection object and the Recordset object. The ConnectionEvent family pertains to operations on the Connection object, and the RecordsetEvent family pertains to operations on the Recordset object.
Connection Events: Events are issued when a transaction on a connection begins, is committed, or is rolled back; when a Command executes; when a warning occurs during a Connection Event operation; or when a Connection starts or ends.
Recordset Events: Events are issued around asynchronous fetch operations as well as when you navigate through the rows of a Recordset object, change a field in a row of a Recordset, change a row in a Recordset, open a Recordset with a server-side cursor, close a Recordset, or make any change whatsoever in the Recordset.
The following tables summarize the events and their descriptions.
| ConnectionEvent | Description |
|---|---|
| BeginTransComplete, CommitTransComplete, RollbackTransComplete | Transaction Management - Notification that the current transaction on the connection has started, committed, or rolled back. |
| WillConnect, ConnectComplete, Disconnect | Connection Management - Notification that the current connection will start, has started, or has ended. |
| WillExecute, ExecuteComplete | Command Execution Management - Notification that the execution of the current command on the connection will start or has ended. |
| InfoMessage | Informational - Notification that there is additional information about the current operation. |
| RecordsetEvent | Description |
|---|---|
| FetchProgress, FetchComplete | Retrieval Status - Notification of the progress of a data retrieval operation, or that the retrieval operation has completed. These events are only available if the Recordset was opened using a client-side cursor. |
| WillChangeField, FieldChangeComplete | Field Change Management - Notification that the value of the current field will change, or has changed. |
| WillMove, MoveComplete, EndOfRecordset | Navigation Management - Notification that the current row position in a Recordset will change, has changed, or has reached the end of the Recordset. |
| WillChangeRecord, RecordChangeComplete | Row Change Management - Notification that something in the current row of the Recordset will change, or has changed. |
| WillChangeRecordset, RecordsetChangeComplete | Recordset Change Management - Notification that something in the current Recordset will change, or has changed. |
See Also
ADO Event Instantiation by Language ADO Events Event Parameters How Event Handlers Work Together Types of Events