RecordStatus Property

    Example    Applies To   

Returns a value indicating the update status of the current record if it is part of a batch update (ODBCDirect workspaces only).

Return Values

The return value is a Long that can be any of the following constants:

Constant Description
dbRecordUnmodified (Default) The record has not been modified or has been updated successfully.
dbRecordModified The record has been modified and not updated in the database.
dbRecordNew The record has been inserted with the AddNew method, but not yet inserted into the database.
dbRecordDeleted The record has been deleted, but not yet deleted in the database.
dbRecordDBDeleted The record has been deleted locally and in the database.

Remarks

The value of the RecordStatus property indicates whether and how the current record will be involved in the next optimistic batch update.

When a user changes a record, the RecordStatus for that record automatically changes to dbRecordModified. Similarly, if a record is added or deleted, RecordStatus reflects the appropriate constant. When you then use a batch-mode Update method, DAO will submit an appropriate operation to the remote server for each record, based on the record's RecordStatus property.