Navigation:  »No topics above this level«

DELETED()

Advantage Concepts

Return to chapter overview

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).

 

See Also

sp_PackTable

sp_PackTableOnline

Advantage TDataSet Descendant

AdsDeleteRecord

AdsPackTable

AdsRecallRecord

AdsIsRecordDeleted

TAdsSettings.ShowDeleted

Advantage Client Engine API

AdsDeleteRecord

AdsShowDeleted

AdsPackTable

AdsRecallRecord

AdsIsRecordDeleted