Status Property (ADO)


		Contents Index Topic Contents

Status Property - ADO

Indicates the status of the current record with respect to batch updates or other bulk operations.
Applies To
Recordset
Return Values
Returns a sum of one or more of the following RecordStatusEnum values:

Constant Description

adRecOK The record was successfully updated.

adRecNew The record is new.

adRecModified The record was modified.

adRecDeleted The record was deleted.

adRecUnmodified The record was not modified.

adRecInvalid The record was not saved because its bookmark is invalid.

adRecMultipleChanges The record was not saved because it would have affected multiple records.

adRecPendingChanges The record was not saved because it refers to a pending insert.

adRecCanceled The record was not saved because the operation was canceled.

adRecCantRelease The new record was not saved because of existing record locks.

adRecConcurrencyViolation The record was not saved because optimistic concurrency was in use.

adRecIntegrityViolation The record was not saved because the user violated integrity constraints.

adRecMaxChangesExceeded The record was not saved because there were too many pending changes.

adRecObjectOpen The record was not saved because of a conflict with an open storage object.

adRecOutOfMemory The record was not saved because the computer has run out of memory.

adRecPermissionDenied The record was not saved because the user has insufficient permissions.

adRecSchemaViolation The record was not saved because it violates the structure of the underlying database.

adRecDBDeleted The record has already been deleted from the data source.

Remarks
Use the Status property to see what changes are pending for records modified during batch updating. You can also use the Status property to view the status of records that fail during bulk operations such as when you call the Resync, UpdateBatch, or CancelBatch methods on a Recordset object, or set the Filter property on a Recordset object to an array of bookmarks. With this property, you can determine how a given record failed and resolve it accordingly.
Examples
Status Property Example (VB)

Top of Page
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.

Constant	Description

adRecOK	The record was successfully updated.
adRecNew	The record is new.
adRecModified	The record was modified.
adRecDeleted	The record was deleted.
adRecUnmodified	The record was not modified.
adRecInvalid	The record was not saved because its bookmark is invalid.
adRecMultipleChanges	The record was not saved because it would have affected multiple records.
adRecPendingChanges	The record was not saved because it refers to a pending insert.
adRecCanceled	The record was not saved because the operation was canceled.
adRecCantRelease	The new record was not saved because of existing record locks.
adRecConcurrencyViolation	The record was not saved because optimistic concurrency was in use.
adRecIntegrityViolation	The record was not saved because the user violated integrity constraints.
adRecMaxChangesExceeded	The record was not saved because there were too many pending changes.
adRecObjectOpen	The record was not saved because of a conflict with an open storage object.
adRecOutOfMemory	The record was not saved because the computer has run out of memory.
adRecPermissionDenied	The record was not saved because the user has insufficient permissions.
adRecSchemaViolation	The record was not saved because it violates the structure of the underlying database.
adRecDBDeleted	The record has already been deleted from the data source.