Kbase 16674: Persistent procedures and database triggers
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Persistent procedures and database triggers
This Kbase points out a diffrence between user interface triggers and
database triggers.
Unlike user interface triggers which associate a block of code with an
event/(singular)widget pair, the database triggers associate a block
of code with an event/table(or column) pair. This makes sense for what
database triggers are designed for, that is, handrolling referential
integrity.
If many procedures are run persistent, each having its own version of
a database trigger, the one last run registers the database trigger
and that's therefore the one in force.
All other procedures running persistent will refer to the version of
the database trigger supplied by the procedure last run.
RKE 19 Feb 1997
Progress Software Technical Support Note # 16674