Was this helpful?
Summary of Frame Behavior Options
The following table provides a summary of the available frame behavior specifications for Browse and Update frames.
Behavior
Frame Types
Default
Alternatives
Qualification Processing
Browse, Update
Enable (allow user query qualifications)
Disable (prohibit user query qualifications)
Next Master Menuitem
Browse, Update
Enable (include Next menu item for multiple Master table row retrieval)
Disable (no Next menu item; allow single Master table row retrieval only)
Locks Held on Displayed Data
Update
None (displayed data is not locked from other users while being updated)
DBMS (displayed data is locked from other users until the update is committed)
Optimistic (data is updated only if the row has not been changed by another user since the row was retrieved from the database)
Update Integrity Rule
Update
Cascade (updates to the Master table join column also cause updates of corresponding Detail table rows)
Restrict (updates to the Master table join column not allowed if corresponding Detail rows exist); or
DBMS (use DBMS rule to handle Detail table join column updates)
Delete Integrity Rule
Update
Cascade (Master table deletions cause deletion of corresponding Detail table rows)
Restrict (Master table deletions not allowed if corresponding Detail table rows exist); or
DBMS (use DBMS rule to handle Detail table deletions)
The following sections describe each of the defaults and the alternative behaviors in detail. The last section provides steps you can use to change the defaults, if necessary.
Note:  You can combine the various frame behaviors to control how users retrieve records on a Browse or Update frame.
Last modified date: 11/09/2022