How Data Is Modified
QBF displays the data from your query on a data display form in the Update frame. You can edit or delete this data, with the following exceptions:
• If the table or tables you are accessing have permissions assigned to them, you need permission to perform an update.
• If JoinDef update rules specify that the table or tables you are accessing cannot be updated, you cannot update columns in that JoinDef.
• If JoinDef update rules have been applied to a join column on the frame, the cursor cannot stop on that field.
• Delete rules have been established to prevent deletion of the rows in the underlying tables.
For more information on restrictions for updating JoinDefs, see Update and Delete Rules in the chapter “Using JoinDefs in QBF.”
To edit the data, type your corrections over the displayed text. QBF does not commit your changes to the actual database as you enter them, but stores them in a temporary buffer. To save your changes and update the database, choose Save on the Update frame data display form menu.
Within QBF, you can change only one row of data at a time. However, you can use the SQL update statement in the Interactive Terminal Monitor to change all qualifying rows of data at one time.
Update Frame Data Display Form Operations
The operations for use with the Update frame's data display form vary, depending on the type of query target and whether the format is for a table field or simple fields. QBF automatically presents the operations that are appropriate for the query target and format you chose.
NextMaster
Displays the next row of data from master and associated detail table fields.
NxtDetail
Displays the next row of detail. (This operation is valid only for JoinDefs in simple‑field format.)
AddDetail
Adds a new detail record to the currently displayed master. (This operation is valid only for JoinDefs in simple‑field format.)
Next
Displays the next frame of data.
Query
Returns to the Update frame query form and clears all fields so that you can enter a new query, including sort sequence and order values.
Delete
Deletes the entry in the database, as shown on a simple‑fields data display form. Displays a new menu to specify the deletion on a table‑field form or Master/Detail JoinDef.
Save
Saves the changes from this session in the database.
Help, End
Standard operations.
Add New Detail Rows to a JoinDef
Use the AddDetail operation on the QBF Update frame data display menu to add detail table records when both the master and detail table of a join definition are displayed as simple fields.
To add a new detail record to a joindef
1. When a master table record and corresponding detail record are displayed, position the cursor on the first simple field for the detail table.
2. Type the data for the new record over the existing data in the currently displayed detail record.
3. Instead of saving the modified record, choose the AddDetail operation from the menu.
QBF writes the new detail record into a temporary buffer and redisplays the prior detail record (as it appeared before you overtyped it with the new data). If desired, you can continue to add additional records by repeating the preceding procedure. Be sure to choose AddDetail rather than Save to write the new record to the buffer; otherwise, you overwrite the existing record rather than add a new one.
4. Choose Save.
The new records are committed to the database.
Do not choose AddDetail until you have typed the new data into the existing record. If you choose this menu option before typing the new data, one of the following occurs:
• If duplicates are allowed, QBF enters the record that currently appears in the window as a duplicate record.
• If duplicates are not allowed, an error message displays.
Last modified date: 08/14/2024