[<<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