6. Defining Frames with Visual Queries : Specifying Frame Behaviors : The Delete Integrity Rule
 
Share this page                  
The Delete Integrity Rule
The Delete Integrity Rule frame behavior affects the deletion of records from Update frames with both Master and Detail tables. The default behavior is to delete any corresponding Detail table records when a user deletes a Master table record.
Use the Delete Integrity Rule frame behavior in combination with the Delete specifications on the visual query window. See Defining Update Frames for a discussion of how to control the deletion of records on Update frames.
You also can specify that Vision use a DBMS rule that you have created previously to determine how to handle deletions to Detail table records. 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.