JavaScript Editor js editor     Web development 



Main Page

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



JavaScript Editor js editor     Web development