6. Defining Frames with Visual Queries : Specifying Frame Behaviors : The Update Integrity Rule
 
Share this page                  
The Update Integrity Rule
If both the following conditions occur:
An Update frame uses both a Master table and Detail table in its visual query
A user changes the value in a join column for a record in the Master table
Then Vision's default action is to change that value for all corresponding records in the Detail table. A Detail table record corresponds to the current Master table record if it has the same value as the Master table in a join column.
Change this default to either of the following:
Restrict updates so that the user cannot change the value of the join column in a Master table record if corresponding Detail table records exist
Allow the DBMS to handle Detail join column updates based on a rule that has been created previously
A rule is a mechanism to invoke a database procedure whenever a specific condition is true. See the SQL Reference Guide for more information about rules and procedures.
This frame behavior only applies to Update frames.