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.
Last modified date: 01/30/2023