RecordStatus Property
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.