Ingres 11.0 | Update and Delete Rules

Character-based Querying and Reporting Tools User Guide > Character-based Querying and Reporting Tools User Guide > Using JoinDefs in QBF > Update and Delete Rules

Was this helpful?

Update and Delete Rules

A JoinDef allows you to modify data in single or multiple tables using a form. You can use the form to delete or update information in the tables. QBF provides update and delete rules that allow you to control the impact of changes made when executing queries on multiple tables. These rules allow you to specify the fields in which a user can perform updates and the tables from which a user can delete records.

To reach the JoinDef Update & Delete Rules frame, choose Rules on the JoinDef Definition frame or the Join Specification frame.

Joins

Goes to the JoinDef Specification frame.

Cancel

Cancels any changes made in this frame and returns to the JoinDef Definition frame.

ListChoices

Lists the available choices for the selected field.

Help, End

Perform standard operations.

Last modified date: 01/30/2023