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