Progress
SQL-89
Guide and Reference
Database Triggers
If a table has database triggers defined in the schema, then accessing rows in that table with Progress/SQL statements causes those triggers to execute. Table 3–6 lists the SQL statements that can cause schema triggers to execute.
Schema triggers execute in both interactive SQL and ESQL. You cannot define session triggers in Progress/SQL.
Progress manages SQL write triggers for INSERT and searched UPDATE statements by deferring execution of all write triggers until the entire searched UPDATE or INSERT statement has executed. However, write triggers are a part of the statement’s transaction, so if a trigger fails, the entire searched UPDATE or DELETE statement is undone.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |