Database Triggers
From Lianjapedia
Revision as of 10:00, 2 February 2018 by Yvonne.milne (Talk | contribs)
See Also
Custom Delegates, Data Files Tab, Event Delegate Sequences
Database Events
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 a database is closed |
DBC_OPENDATA | Occurs when a database is opened |
Table Triggers
Table triggers (subset of table 'SQL Constraints') are triggered by certain table operations. They can have code associated with them that is run automatically when the event occurs.
Event | Description |
---|---|
ONAFTERDELETE | Occurs after a delete operation |
ONAFTERINSERT | Occurs after an insert operation |
ONAFTERUPDATE | Occurs after an update operation |
ONCLOSE | Occurs when a table is closed |
ONBEFOREDELETE / ONDELETE | Occurs before a delete operation |
ONBEFOREINSERT / ONINSERT | Occurs before an insert operation |
ONOPEN | Occurs when a table is opened |
ONBEFOREUPDATE / ONUPDATE | Occurs before an update operation |
Pages in category "Database Triggers"
The following 7 pages are in this category, out of 7 total.