Share via


Database Container Events

You can enable Database Container (DBC) events and add code to specific events on data contained in a database. You can create this code manually in an external file, or you can use the Database Properties dialog box, which provides a template for you to complete in the location you specify. The following table describes the available DBC events:

DBC Events Description
DBC_Activate Occurs when an open database becomes current.
DBC_Deactivate Occurs when a database ceases to be current.
DBC_BeforeAddRelation Occurs before a relation is added to the database.
DBC_AfterAddRelation Occurs after a relation is added to the database successfully.
DBC_BeforeAddTable Occurs before a table is added to an open database.
DBC_AfterAddTable Occurs after a table is added to an open database.
DBC_BeforeAppendProc Occurs before the append operation in the current DBC stored procedure completes. Use to prevent the append operation. Also, use to discover the name of the DBC involved.
DBC_AfterAppendProc Occurs after the APPEND PROC operation completes.
DBC_BeforeCloseTable Occurs before the table or view is closed.
DBC_AfterCloseTable Occurs after a table or view is closed.
DBC_BeforeCopyProc Occurs before the copy procedure operation in the current DBC begins. Use to prevent the operation. Also, use to discover the name of the DBC involved.
DBC_AfterCopyProc Occurs after the copy procedure operation in the current DBC completes. Use to discover the name of the DBC involved.
DBC_BeforeCreateConnection Occurs before a connection is created. Use to prevent connection creation or connection designer opening.
DBC_AfterCreateConnection Occurs after a connection is created.
DBC_BeforeCreateOffline Occurs before a view is taken offline. Use to prevent offline view.
DBC_AfterCreateOffline Occurs after CREATEOFFLINE( ) has completed.
DBC_BeforeCreateTable Occurs before a table is created in an open database.
DBC_AfterCreateTable Occurs after a table is created in an open database.
DBC_BeforeCreateView Occurs before a view is created. Use to prevent view from being created or view designer from being opened.
DBC_AfterCreateView Occurs after view creation is completed.
DBC_BeforeDBGetProp Occurs before DBGetProp( ) runs.
DBC_AfterDBGetProp Occurs after DBGetProp( ) completes.
DBC_BeforeDBSetProp Occurs before DBSetProp( ) runs. Event also fires when "Event" property is changed.
DBC_AfterDBSetProp Occurs after DBSetProp( ) completes. Event also fires when "Event" property is changed.
DBC_BeforeDeleteConnection Occurs before a connection is dropped.
DBC_AfterDeleteConnection Occurs after a connection is dropped.
DBC_BeforeDropOffline Occurs before a view is returned to online. Use to prevent bringing offline view back online.
DBC_AfterDropOffline Occurs after DROPOFFLINE( ) has completed.
DBC_BeforeDropRelation Occurs before a relation is dropped from a database.
DBC_AfterDropRelation Occurs after a relation is dropped from a database successfully.
DBC_BeforeDropTable Occurs before the table is removed from the DBC and deleted from disk.
DBC_AfterDropTable Occurs after a table is removed from the DBC and deleted from disk.
DBC_BeforeDropView Occurs before a view is removed from the DBC. Use to prevent view from being dropped.
DBC_AfterDropView Occurs after view is removed from the DBC.
DBC_BeforeModifyConnection Occurs before a connection is modified.
DBC_AfterModifyConnection Occurs after a connection is modified.
DBC_BeforeModifyProc Occurs before the DBC-stored procedure in an open DBC is modified. Use to prevent modification. Also, use to discover the name of the current DBC.
DBC_AfterModifyProc Occurs after modifications have been made and the stored procedure file for the DBC has been closed.
DBC_BeforeModifyTable Occurs before a table is modified.
DBC_AfterModifyTable Occurs after a table is modified.
DBC_BeforeModifyView Occurs before a view is modified.
DBC_AfterModifyView Occurs after a view is modified.
DBC_BeforeOpenTable Occurs before a table or view is opened.
DBC_AfterOpenTable Occurs after a table or view is opened.
DBC_BeforeRemoveTable Occurs before a table is removed from the DBC.
DBC_AfterRemoveTable Occurs after table removal is complete.
DBC_BeforeRenameConnection Occurs before a connection is renamed.
DBC_AfterRenameConnection Occurs after a connection is renamed.
DBC_BeforeRenameTable Occurs before a table is renamed.
DBC_AfterRenameTable Occurs after a table is renamed.
DBC_BeforeRenameView Occurs before a view is renamed.
DBC_AfterRenameView Occurs after a view is renamed.
DBC_BeforeValidateData Occurs before VALIDATE DATABASE executes. Return .F. to prevent the DBC from being validated.
DBC_AfterValidateData Occurs after VALIDATE DATABASE completes.
DBC_ModifyData Occurs immediately after Modify Data is issued. Use to prevent opening of Schema window. Also, can open a closed database.
DBC_OpenData Occurs when a database opens or when a MODIFY DATABASE command is issued against a closed database. Use to close an open database.
DBC_CloseData Closes an open database.
DBC_PackData Occurs before PACK DATABASE executes. Use to prevent the DBC from being packed.

See Also

Enabling or Disabling DBC Events | Adding Code to a DBC Event