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