You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

[ |../../index.htm#lansa/reptut01_0355.htm]
You are here:

Step 7. Review Table Level Triggers

A database trigger is a condition that is defined for a field or table in the repository. Typically, triggers are used to move complex logic to the table definition.  The trigger definition links a trigger function to a specific database operation and condition. This function is invoked automatically when a specific type of I/O operation occurs to a table and when a specific set of conditions are met.
Similar to validation checks, LANSA triggers help to centralize the business logic of your application. 
A LANSA trigger function is a special type of LANSA function, which is invoked automatically when a specific type of I/O operation occurs on a table (Open, Close, Read, Insert, Update and Delete) and when a specific set of conditions are met.
For example, as an audit trail, you might create a trigger to print before and after recording specific values.
Triggers are not covered in this exercise because you need to write code in order to create a trigger function.
[ |../../index.htm#lansa/reptut01_0355.htm]

  • No labels