RecordStatus Property

Applies To

Dynamic-Type Recordset object, Dynaset-Type Recordset object, Forward-Only-Type Recordset object, Recordset object, Snapshot-Type Recordset object.

Description

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.

Example

See the DefaultCursorDriver property example.