Progress
Database Design
Guide
Trigger Types
There are two types of Java triggers provided: statement and row.
Statement triggers are tied to the SQL-92 statement boundaries. These triggers are only observed through the SQL-92 interface. Row triggers are fired when database events occur regardless of the interface to the database.
EXAMPLEThe following code illustrates an example of a statement trigger:
NOTE: The UPDATE statement executes only once regardless of how many rows are deleted.EXAMPLEThe following code examples illustrates a row trigger:
NOTES
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |