[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
DELETED()
Return the deleted status of the current record
------------------------------------------------------------------------------
Syntax
DELETED() --> lDeleted
Returns
DELETED() returns true (.T.) if the current record is marked for
deletion; otherwise, it returns false (.F.). If there is no database
file in USE in the current work area, DELETED() returns false (.F.).
Description
DELETED() is a database function that determines if the current record
in the active work area is marked for deletion. Since each work area
with an open database file can have a current record, each work area has
its own DELETED() value.
By default, DELETED() operates on the currently selected work area. It
will operate on an unselected work area if you specify it as part of an
aliased expression (see example below).
In applications, DELETED() is generally used to query the deleted status
as a part of record processing conditions, or to display the deleted
status as a part of screens and reports.
Examples
. This example uses DELETED() in the current and in an
unselected work area:
USE Customer NEW
USE Sales NEW
? DELETED() // Result: .F.
DELETE
? DELETED() // Result: .T.
? Customer->(DELETED()) // Result: .F.
. This example uses DELETED() to display a record's deleted
status in screens and reports:
@ 1, 65 SAY IF(DELETED(), "Inactive", "Active")
Files Library is CLIPPER.LIB.
See Also:
DELETE
PACK
RECALL
SET DELETED
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson