Restore records marked for deletion
RECALL [<scope>] [WHILE <lCondition>] [FOR <lCondition>]
<scope> is the portion of the current database file to RECALL. The default scope is the current record, or NEXT 1. If a condition is specified, the default scope becomes ALL.
WHILE <lCondition> specifies the set of records meeting the condition from the current record until the condition fails.
FOR <lCondition> specifies the conditional set of records to RECALL within the given scope.
RECALL is a database command that restores records marked for deletion in the current work area. This is the inverse of the DELETE command. If DELETED is ON, RECALL can restore the current record or a specific record, if you specify a RECORD scope. Note that once you PACK a database file, all marked records have been physically removed from the file and cannot be recovered.
In a network environment, RECALLing the current record requires an RLOCK(). RECALLing several records requires an FLOCK() or EXCLUSIVE USE of the current database file. Refer to the “Network Programming” chapter for more information.
. This examples show the results of RECALL: USE Sales NEW // DELETE RECORD 4 ? DELETED() // Result: .T. // RECALL ? DELETED() // Result: .F.
DELETE, DELETED, FLOCK(), PACK, RLOCK(), SET DELETED