Difference between revisions of "RECALL"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Reinstate records that are marked for deletion | Reinstate records that are marked for deletion | ||
| Line 16: | Line 12: | ||
==See Also== | ==See Also== | ||
| − | [[DELETE]], [[PACK]], [[SET DELETED]], [[SET FILTER]], [[ZAP]] | + | [[DELETE]], [[PACK]], [[SCOPE]], [[SET DELETED]], [[SET FILTER]], [[ZAP]] |
==Description== | ==Description== | ||
The RECALL command is used to reinstate those records that are marked for deletion in the active table. The default scope for the RECALL command is only to recall the current record. Records marked for deletion cannot be recalled once a table has been packed. If SET FILTER TO is in effect, then any records that do not satisfy the filter condition are not recalled. While SET DELETED ON is in effect, all deleted records are automatically filtered and cannot be recalled. | The RECALL command is used to reinstate those records that are marked for deletion in the active table. The default scope for the RECALL command is only to recall the current record. Records marked for deletion cannot be recalled once a table has been packed. If SET FILTER TO is in effect, then any records that do not satisfy the filter condition are not recalled. While SET DELETED ON is in effect, all deleted records are automatically filtered and cannot be recalled. | ||
| + | |||
| + | ====<scope>==== | ||
| + | The default [[SCOPE]] is the current record unless a FOR or WHILE condition is specified. | ||
====FOR <condition>==== | ====FOR <condition>==== | ||
| Line 28: | Line 27: | ||
If the WHILE clause is specified, then the RECALL command terminates as soon as the specified <condition> is .F.. The WHILE clause is often used in conjunction with the FIND or SEEK commands to RECALL records which have a common key. | If the WHILE clause is specified, then the RECALL command terminates as soon as the specified <condition> is .F.. The WHILE clause is often used in conjunction with the FIND or SEEK commands to RECALL records which have a common key. | ||
| − | If the table is indexed, then the records are read in index order unless you specify RECORD <expN>, as the scope. If the currently selected table is not opened exclusively, | + | If the table is indexed, then the records are read in index order unless you specify RECORD <expN>, as the scope. If the currently selected table is not opened exclusively, Recital will automatically lock each record in turn, recall it if required, then unlock the record. |
Recital positions to EOF when RECALL specifies FOR or WHILE conditions and SET COMPATIBLE TO <XBASE> is in effect. | Recital positions to EOF when RECALL specifies FOR or WHILE conditions and SET COMPATIBLE TO <XBASE> is in effect. | ||
| Line 43: | Line 42: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Table Basics]] | [[Category:Table Basics]] | ||
[[Category:Table Basics Commands]] | [[Category:Table Basics Commands]] | ||
| + | [[Category:Data Commands]] | ||
Latest revision as of 16:13, 3 September 2010
Contents
Purpose
Reinstate records that are marked for deletion
Syntax
RECALL [<scope>]
[FOR <condition>]
[WHILE <condition>]
See Also
DELETE, PACK, SCOPE, SET DELETED, SET FILTER, ZAP
Description
The RECALL command is used to reinstate those records that are marked for deletion in the active table. The default scope for the RECALL command is only to recall the current record. Records marked for deletion cannot be recalled once a table has been packed. If SET FILTER TO is in effect, then any records that do not satisfy the filter condition are not recalled. While SET DELETED ON is in effect, all deleted records are automatically filtered and cannot be recalled.
<scope>
The default SCOPE is the current record unless a FOR or WHILE condition is specified.
FOR <condition>
If the FOR clause is specified, then only those records which satisfy the <condition> are considered for recalling. If no <scope> was specified and the FOR clause was specified, then a scope of ALL is used.
WHILE <condition>
If the WHILE clause is specified, then the RECALL command terminates as soon as the specified <condition> is .F.. The WHILE clause is often used in conjunction with the FIND or SEEK commands to RECALL records which have a common key.
If the table is indexed, then the records are read in index order unless you specify RECORD <expN>, as the scope. If the currently selected table is not opened exclusively, Recital will automatically lock each record in turn, recall it if required, then unlock the record.
Recital positions to EOF when RECALL specifies FOR or WHILE conditions and SET COMPATIBLE TO <XBASE> is in effect.
Example
use patrons index events delete for event = "OPERA" and eventdate < date() seek "OPERA" recall rest while event = "OPERA" and eventdate < date()
Products
Recital Server, Recital
