Difference between revisions of "Category:Database Triggers"
From Lianjapedia
Barrymavin (Talk | contribs) (Created page with "{{DISPLAYTITLE:Database Triggers}}") |
Yvonne.milne (Talk | contribs) |
||
(One intermediate revision by the same user not shown) | |||
Line 1: | Line 1: | ||
{{DISPLAYTITLE:Database Triggers}} | {{DISPLAYTITLE:Database Triggers}} | ||
+ | ==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. | ||
+ | |||
+ | {| class="wikitable" width="100%" | ||
+ | !width="30%"|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. | ||
+ | |||
+ | {| class="wikitable" width="100%" | ||
+ | !width="30%"|Event||Description | ||
+ | |- | ||
+ | |[[ONAFTERDELETE Table Constraint|ONAFTERDELETE]]||Occurs after a delete operation | ||
+ | |- | ||
+ | |[[ONAFTERINSERT Table Constraint|ONAFTERINSERT]]||Occurs after an insert operation | ||
+ | |- | ||
+ | |[[ONAFTERUPDATE Table Constraint|ONAFTERUPDATE]]||Occurs after an update operation | ||
+ | |- | ||
+ | |[[ONCLOSE Table Constraint|ONCLOSE]]||Occurs when a table is closed | ||
+ | |- | ||
+ | |[[ONBEFOREDELETE Table Constraint|ONBEFOREDELETE]] / [[ONDELETE Table Constraint|ONDELETE]]||Occurs before a delete operation | ||
+ | |- | ||
+ | |[[ONBEFOREINSERT Table Constraint|ONBEFOREINSERT]] / [[ONINSERT Table Constraint|ONINSERT]]||Occurs before an insert operation | ||
+ | |- | ||
+ | |[[ONOPEN Table Constraint|ONOPEN]]||Occurs when a table is opened | ||
+ | |- | ||
+ | |[[ONBEFOREUPDATE Table Constraint|ONBEFOREUPDATE]] / [[ONUPDATE Table Constraint|ONUPDATE]]||Occurs before an update operation | ||
+ | |- | ||
+ | |} |
Latest revision as of 10:00, 2 February 2018
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.