Database Events

From Lianjapedia
Jump to: navigation, search

Purpose

Database events are triggered by certain database operations

See Also

ADATABASES(), ALTER TABLE, ADD TABLE, ALTER INDEX, CLOSE DATABASES, CLOSE TABLES, COMPILE DATABASE, CREATE DATABASE, CREATE TABLE, CREATE INDEX, CREATE VIEW, DATABASE(), DBUSED(), DISPLAY DATABASE, DISPLAY INDEXES, DISPLAY TABLES, DROP DATABASE, DROP INDEX, DROP TABLE, Event Delegate Sequences, GETENV(), LIST DATABASE, LIST INDEXES, LIST TABLES, OPEN DATABASE, PACK DATABASE, REBUILD DATABASE, REINDEX DATABASE, SET AUTOCATALOG, SET DBCEVENTS, SET EXCLUSIVE, SQL Constraints, USE

Description

Database events are triggered by certain database operations. They can have code associated with them that is run automatically when the event occurs.

Event Description
DBC_AFTERDELETE Occurs after a delete operation
DBC_AFTERINSERT Occurs after an insert operation
DBC_AFTEROPENTABLE Occurs on an open table operation after the table has been opened (from v5.0)
DBC_AFTERUPDATE Occurs after an update operation
DBC_BEFOREDELETE Occurs before a delete operation
DBC_BEFOREINSERT Occurs before an insert operation
DBC_BEFOREOPENTABLE Occurs on an open table operation before the table has been opened (from v5.0)
DBC_BEFOREUPDATE Occurs before an update operation
DBC_CLOSEDATA Occurs when a database is closed
DBC_OPENDATA Occurs when a database is opened

When a database is opened, if dbc_library.prg (.dbo compiled/runtime) procedure library file exists, it is loaded as a system library.

Database Events tab


Programs associated with database events should reside in the relevant database's directory.

These can be created and modified from the Events tab in the Data Workspace when a database is open.