You can restore records that are marked for deletion but have not yet been removed.
To restore a record marked for deletion
-
Open the table in a browse window.
-
In the browse window, insert the cursor in the record marked for deletion.
-
On the Table menu, click Toggle Deletion Mark.
Tip: You can also click the deletion column next to the record marked for deletion to remove the deletion marker. The deletion marker is removed from the deletion column.
To restore multiple records marked for deletion
-
Open the table in a browse window.
-
On the Table menu, click Recall Records
The Recall dialog box opens.
-
In the Scope box of the Recall dialog box, select the range of records you want to restore.
-
In the For box, type an expression that records must meet to include for restoration. To build an expression, click the ellipsis (...) button.
-
In the While box, type an expression that evaluates to true in order to continue evaluating records to include for restoration.
-
When you are finished, click Recall.
For more information, see Recall (Records) Dialog Box.
To restore deleted records programmatically
-
Use the RECALL command.
For more information, see RECALL Command.