Difference between revisions of "Database Events"
Yvonne.milne (Talk | contribs) m (Yvonne.milne moved page SQL Database Events to Database Events without leaving a redirect) |
Yvonne.milne (Talk | contribs) |
||
Line 11: | Line 11: | ||
!width="30%"|Event||Description | !width="30%"|Event||Description | ||
|- | |- | ||
− | |[[DBC_CLOSEDATA]]||Occurs when | + | |[[DBC_AFTERDELETE]]||Occurs after a delete operation |
+ | |- | ||
+ | |[[DBC_AFTERINSERT]]||Occurs after an insert operation | ||
+ | |- | ||
+ | |[[DBC_AFTERUPDATE]]||Occurs after an update operation | ||
+ | |- | ||
+ | |[[DBC_BEFOREDELETE]]||Occurs before a delete operation | ||
+ | |- | ||
+ | |[[DBC_BEFOREINSERT]]||Occurs before an insert operation | ||
+ | |- | ||
+ | |[[DBC_BEFOREUPDATE]]||Occurs before an update operation | ||
+ | |- | ||
+ | |[[DBC_CLOSEDATA]]||Occurs when an update closes | ||
|- | |- | ||
|[[DBC_OPENDATA]]||Occurs when a database is opened | |[[DBC_OPENDATA]]||Occurs when a database is opened | ||
|- | |- | ||
|} | |} | ||
+ | |||
+ | When a database is opened, if dbc_library.prg (.dbo compiled/runtime) exists it is loaded as a system library. | ||
Programs associated with database events should reside in the relevant database's directory. | Programs associated with database events should reside in the relevant database's directory. |
Revision as of 05:24, 17 October 2016
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, GETENV(), LIST DATABASE, LIST INDEXES, LIST TABLES, OPEN DATABASE, PACK DATABASE, REBUILD DATABASE, REINDEX DATABASE, SET AUTOCATALOG, SET EXCLUSIVE, 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_AFTERUPDATE | Occurs after an update operation |
DBC_BEFOREDELETE | Occurs before a delete operation |
DBC_BEFOREINSERT | Occurs before an insert operation |
DBC_BEFOREUPDATE | Occurs before an update operation |
DBC_CLOSEDATA | Occurs when an update closes |
DBC_OPENDATA | Occurs when a database is opened |
When a database is opened, if dbc_library.prg (.dbo compiled/runtime) exists it is loaded as a system library.
Programs associated with database events should reside in the relevant database's directory.