DELETED()

Scalar function that returns the deleted status of the current record.

Supported in SQL:	Yes
Supported in Navigational:	Yes

Syntax

DELETED( [<tablealias>] ) à lDeleted

Return Values

DELETED() returns true (.T.) if the current record is marked for deletion; otherwise, it returns false (.F.).

Remarks

DELETED() is a database function that determines if the current record in the table is marked for deletion. Since each table has a current record, each table has its own DELETED() value.

In SQL usage, the DELETED() scalar function accepts an optional table alias that can be used when the table reference is ambiguous (e.g., in the case of a join where multiple tables are involved).