Database Container Events

Database container (DBC) events occur when actions occur in a database. You can add procedure code to these events that executes when those events occur.

The following table describes available DBC events.

DBC events	Description
DBC_Activate	Occurs when an open database becomes the current database.
DBC_Deactivate	Occurs when a database is no longer the current database.
DBC_BeforeAddRelation	Occurs before adding a relation to the database.
DBC_AfterAddRelation	Occurs after adding a relation to the database successfully.
DBC_BeforeAddTable	Occurs before adding a table to an open database.
DBC_AfterAddTable	Occurs after adding a table to an open database.
DBC_BeforeAppendProc	Occurs before completing the APPEND PROCEDURES operation in the current DBC stored procedue. Use to prevent the append operation. Also, use to discover the name of the DBC involved.
DBC_AfterAppendProc	Occurs after completing the APPEND PROCEDURES operation.
DBC_BeforeCloseTable	Occurs before closing a table or view.
DBC_AfterCloseTable	Occurs after closing a table or view.
DBC_BeforeCopyProc	Occurs before beginning the copy procedure operation in the current DBC. Use to prevent the operation. Also, use to discover the name of the DBC involved.
DBC_AfterCopyProc	Occurs after completing the copy procedure operation in the current DBC. Use to discover the name of the DBC involved.
DBC_BeforeCreateConnection	Occurs before creating a connection. Use to prevent creating the connection or opening the connection designer.
DBC_AfterCreateConnection	Occurs after creating a connection.
DBC_BeforeCreateOffline	Occurs before taking a view offline. Use to prevent offline view.
DBC_AfterCreateOffline	Occurs after completing the CREATEOFFLINE( ) fuction.
DBC_BeforeCreateTable	Occurs before creating a table in an open database.
DBC_AfterCreateTable	Occurs after creating a table in an open database.
DBC_BeforeCreateView	Occurs before creating a view. Use to prevent view from being created or view designer from being opened.
DBC_AfterCreateView	Occurs after creating a view.
DBC_BeforeDBGetProp	Occurs before running DBGETPROP( ).
DBC_AfterDBGetProp	Occurs after completing DBGETPROP( ).
DBC_BeforeDBSetProp	Occurs before running DBSETPROP( ) or when the "Event" property is changed.
DBC_AfterDBSetProp	Occurs after completing DBSETPROP( ) or when the "Event" property is changed.
DBC_BeforeDeleteConnection	Occurs before dropping a connection.
DBC_AfterDeleteConnection	Occurs after dropping a connection.
DBC_BeforeDropOffline	Occurs before returning a view to online. Use to prevent bringing offline view back online.
DBC_AfterDropOffline	Occurs after completing DROPOFFLINE( ).
DBC_BeforeDropRelation	Occurs before dropping a relation from a database.
DBC_AfterDropRelation	Occurs after dropping a relation from a database successfully.
DBC_BeforeDropTable	Occurs before removing a table from the DBC and deleting from disk.
DBC_AfterDropTable	Occurs after removing a table from the DBC and deleting from disk.
DBC_BeforeDropView	Occurs before removing a view from the DBC. Use to prevent view from being dropped.
DBC_AfterDropView	Occurs after removing a view from the DBC.
DBC_BeforeModifyConnection	Occurs before modifying a connection.
DBC_AfterModifyConnection	Occurs after modifying a connection.
DBC_BeforeModifyProc	Occurs before modifying a DBC-stored procedure in an open DBC. Use to prevent modification. Also, use to discover the name of the current DBC.
DBC_AfterModifyProc	Occurs after modifying and closing the stored procedure file for the DBC.
DBC_BeforeModifyTable	Occurs before modifying a table.
DBC_AfterModifyTable	Occurs after modifying a table.
DBC_BeforeModifyView	Occurs before modifying a view.
DBC_AfterModifyView	Occurs after modifying a view.
DBC_BeforeOpenTable	Occurs before opening a table or view.
DBC_AfterOpenTable	Occurs after opening a table or view.
DBC_BeforeRemoveTable	Occurs before removing a table from the DBC.
DBC_AfterRemoveTable	Occurs after removing a table from the DBC.
DBC_BeforeRenameConnection	Occurs before renaming a connection.
DBC_AfterRenameConnection	Occurs after renaming a connection.
DBC_BeforeRenameTable	Occurs before renaming a table.
DBC_AfterRenameTable	Occurs after renaming a table.
DBC_BeforeRenameView	Occurs before renaming a view.
DBC_AfterRenameView	Occurs after renaming a view.
DBC_BeforeValidateData	Occurs before executing VALIDATE DATABASE. Return .F. to prevent the DBC from being validated.
DBC_AfterValidateData	Occurs after completing VALIDATE DATABASE.
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 executing PACK DATABASE. Use to prevent the DBC from being packed.

See Also

Tasks

How to: Enable or Disable DBC Events

How to: Add Code to a DBC Event

Other Resources

Developing Databases

Working with Database Container Events