ADO Events

See Also   

ADO 2.0 supports events. An event is a notification issued by certain operations before the operation starts or after it completes. An event is actually a call to an event handler routine that you define in your application. See ADO Event Instantiation by Language.

There are two families of events. The ConnectionEvent family pertains to operations on the Connection object, and the RecordsetEvent family pertains to operations on the Recordset object.

ADO Event Handler Summary

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.
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.