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
New records are created by calling Resultset.NewRecord or Resultset.Append
Existing records are retrieved from the database by calling Recordset.ExecSql or Transactional.ExecSql
A record that is marked for deletion by calling Recordset.Delete