ADO Event Summary

See Also   

• ADO 2.0 supports events, which are notifications that certain operations are about to occur or have occurred.
  
  
• There are two families of events: ConnectionEvent and RecordsetEvent. The Connection object issues ConnectionEvent events, and the Recordset object issues RecordsetEvent events.
  
  
• Events are processed by event handler routines, which are called before certain operations start or after such operations conclude.
  
  
• Some events are paired. Events called before an operation starts have names of the form WillEvent (Will events) and events called after an operation concludes have names of the form EventComplete (Complete events).
  
  
• The remaining, unpaired events occur only after an operation concludes. (Their names are not formed in any particular pattern.)
  
  
• The event handlers are controlled by the status parameter. Additional information is provided by the error and object parameters.
  
  
• You can request an event handler not to receive any more notifications after the first notification. For example, you could choose to receive only Will events or Complete events.
  
  
• In certain programming languages, events from multiple ADO objects can be processed by one event handler. And although less common, one event can be processed by multiple event handlers.