Status Property

Indicates the status of the current record with respect to batch updates or other bulk operations.

Return Values

Returns a sum of one or more of the following RecordStatusEnum values:

Constant	Value	Description
adRecOK	0	The record was successfully updated.
adRecNew	1	The record is new.
adRecModified	2	The record was modified.
adRecDeleted	4	The record was deleted.
adRecUnmodified	8	The record was not modified.
adRecInvalid	16	The record was not saved because its bookmark is invalid.
adRecMultipleChanges	64	The record was not saved because it would have affected multiple records.
adRecPendingChanges	128	The record was not saved because it refers to a pending insert.
adRecCanceled	256	The record was not saved because the operation was canceled.
adRecCantRelease	1024	The new record was not saved because of existing record locks.
adRecConcurrencyViolation	2048	The record was not saved because optimistic concurrency was in use.
adRecIntegrityViolation	4096	The record was not saved because the user violated integrity constraints.
adRecMaxChangesExceeded	8192	The record was not saved because there were too many pending changes.
adRecObjectOpen	16384	The record was not saved because of a conflict with an open storage object.
adRecOutOfMemory	32768	The record was not saved because the computer has run out of memory.
adRecPermissionDenied	65536	The record was not saved because the user has insufficient permissions.
adRecSchemaViolation	131072	The record was not saved because it violates the structure of the underlying database.
adRecDBDeleted	262144	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 Delete, 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.

Applies To

Recordset

file: /Techref/language/asp/comp/daprop06_3.htm, 6KB, , updated: 1996/11/21 19:01, local time: 2025/8/26 20:50,

^{216.73.216.7,10-2-77-149:LOG IN}

©2025 These pages are served without commercial sponsorship. (No popup ads, etc...).Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE. Questions?

Please DO link to this page! Digg it! / MAKE!

<A HREF="http://www.piclist.com/techref/language/asp/comp/daprop06_3.htm"> Status Property (ADO)</A>

Did you find what you needed?

PICList 2025 contributors:
o List host: MIT, Site host massmind.org, Top posters @none found
- Page Editors: James Newton, David Cary, and YOU!
* Roman Black of Black Robotics donates from sales of Linistep stepper controller kits.
* Ashley Roll of Digital Nemesis donates from sales of RCL-1 RS232 to TTL converters.
* Monthly Subscribers: Gregg Rew. on-going support is MOST appreciated!
* Contributors: Richard Seriani, Sr.

Quick, Easy and CHEAP! RCL-1 RS232 Level Converter in a DB9 backshell
Ashley Roll has put together a really nice little unit here. Leave off the MAX232 and keep these handy for the few times you need true RS232!