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