How Data Is Deleted
You use the Delete operation to erase an entire record (row) of data. The menu on the Update frame for the data display form includes this operation, regardless of the type of query target you specify.
As you delete rows, QBF writes the deletions to a temporary buffer. If you delete one row in a table field, the remaining rows scroll upward.
When you choose Delete on an Update frame with only simple fields displayed in the data display form, the menu is unchanged. In this display format, rows can only be deleted one at a time. QBF does not commit the deletions until you choose Save.
When you choose Delete for a data display form that displays a JoinDef or a form with a table field or both simple fields and a table field, the menu changes. It includes the operations appropriate to the various combinations of query target types and display formats listed next.
To delete a detail row in a JoinDef or in a form that includes a table field, place the cursor on the row to be deleted and choose Delete. When the Delete menu appears, choose DetailRow.
Master
Deletes the master record currently displayed and all its detail records.
AllDetailRows
Deletes all retrieved rows in the table field for the detail tables of the master currently displayed—QBF deletes all rows regardless of whether they are visible in the window.
DetailRow
Deletes the single detail row indicated by the cursor in table‑field display.
Detail
Deletes the currently displayed detail row in simple‑fields display.
ListChoices
Lists the available choices for the selected field on a QBFName.
AllRows
Deletes all retrieved rows in the table field, regardless of whether they are visible in the window.
Row
Deletes the row indicated by the cursor.
Help, End
Standard operations.
Last modified date: 08/28/2024