Kbase P23555: How to create an equivalent to the 4GL write trigger in the
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/02/2004 |
|
Status: Unverified
GOAL:
How to create an equivalent to the 4GL write trigger in the SQL Explorer?
GOAL:
How to create an UPDATE trigger in the SQL Explorer?
FACT(s) (Environment):
Progress 9.1x
FIX:
Triggers for INSERT DELETE and UPDATE can be created for whatever table you wish in the SQL Explorer.
CREATE TRIGGER [ owner_name.]trigname
{ BEFORE | AFTER }
{ INSERT | DELETE | UPDATE [ OF column_name [ , ... ] }
ON table_name
[ REFERENCING { OLDROW [ ,NEWROW ] | NEWROW [ ,OLDROW ] } ]
[ FOR EACH { ROW | STATEMENT } ]
[ IMPORT
java_import_clause ]
BEGIN
java_snippet
END
References to Written Documentation:
Progress SQL-92 Guide and Reference, section CREATE TRIGGER Statement.