Name

RecordStatusEnum Enumeration — (Versions 2.0, 2.1, 2.6, 2.6)

Synopsis

The RecordStatusEnum enumeration indicates the status of a record within a Recordset object with regards to bulk operations such as batch updates.

Table E-40. The RecordStatusEnum Enumeration

Enumeration (ADO/WFC)

Value

Description

adRecCanceled (CANCELED)
256 (&H100)

Indicates that the record has not been saved because the operation was canceled.

adRecCantRelease (CANTRELEASE)
1024 (&H400)

Indicates that the new record has not been saved because of record locks.

adRecConcurrencyViolation (CONCURRENCYVIOLATION)
2048 (&H800)

Indicates that the record has not been saved because optimistic concurrency (the assumption that collisions between data rarely occur, and therefore the row is left unlocked until update or deletion) was in use.

adRecDBDeleted (DBDELETED)
262144 (&H40000)

Indicates that the record has already been deleted from the data source.

adRecDeleted (DELETED)
4

Indicates that the record has been deleted.

adRecIntegrityViolation (INTEGRITYVIOLATION)
4096 (&H1000)

Indicates that the record had not been saved because the user violated integrity constraints.

adRecInvalid (INVALID)
16 (&H10)

Indicates that the bookmark of the record is bad and therefore that record was not saved.

adRecMaxChangesExceeded (MAXCHANGESEXCEEDED)
8192 (&H2000)

Indicates that the record has not been saved because there were too many pending changes.

adRecModified (MODIFIED)
2

Indicates that the record ...

Get ADO: ActiveX Data Objects now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.