Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

[ Image Removed |../../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.

...

  • .

...