Page History
[ |../../index.htm#lansa/reptut01_0360.htm]
You are here:
...
Important Observations
- Field level validation rules are applied before table level validation rules.
- The sequence of rules, combined with the validation actions, is very important in controlling when multiple rules are applied.
- Referential integrity can be added by using table lookup checks. Remember that referential integrity is usually defined in both tables within a relationship. In our example, Department cannot be deleted if Employees exist, and Employees cannot be added unless the Department exists.
- Notice that the trigger function is called after the validation rules are performed. This order of operations prevents invalid data from being passed into the trigger.
- Whenever a validation rule or trigger is changed (at field or table level), the table OAM needs to be recompiled.
...
- Where validation rules are performed in the LANSA architecture.
- What rules are supported at the table level.
- At what level you should specify most of your rules.
- In what order the field and table validation rules are performed.
- How to use a code table lookup rule to create referential integrity.
- That you need to recompile your table after you have changed it.
...
- .
...