The record status
Every record has a record status.
The record status can be retrieved with the Record.RecordStatus method.
The method returns a DataRecordStatus (enum). The enum has 3 elements: New, Existing and ExistingDelete
DataRecordStatus.New
New records are created by calling Resultset.NewRecord or Resultset.Append
DataRecordStatus.Existing
Existing records are retrieved from the database by calling Recordset.ExecSql or Transactional.ExecSql
DataRecordStatus.ExistingDelete
A record that is marked for deletion by calling Recordset.Delete