[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
SET DELETED
Toggle filtering of deleted records
------------------------------------------------------------------------------
Syntax
SET DELETED on | OFF | <xlToggle>
Arguments
ON ignores deleted records.
OFF processes deleted records.
<xlToggle> is a logical expression that must be enclosed in
parentheses. A value of true (.T.) is the same as ON, and a value of
false (.F.) is the same as OFF.
Description
SET DELETED toggles automatic filtering of records marked for deletion in
all work areas. When SET DELETED is ON, most commands ignore deleted
records. If, however, you refer to a record by record number (GOTO or any
command that supports the RECORD scope), the record is not ignored even if
marked for deletion. Additionally, SET DELETED ON has no affect on INDEX
or REINDEXing.
RECALL ALL honors SET DELETED and does not recall any records.
Notes
. Filtering deleted records in a single work area: To confine
the filtering of deleted records to a particular work area, SELECT
the work area, and then SET FILTER TO DELETED().
Examples
. This example illustrates the effect of using SET DELETED:
USE Sales NEW
? LASTREC() // Result: 84
//
DELETE RECORD 4
COUNT TO nCount
? nCount // Result: 84
//
SET DELETED ON
COUNT TO nCount
? nCount // Result: 83
Files Library is CLIPPER.LIB.
See Also:
DELETE
DELETED()
RECALL
SET FILTER
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson