please dont rip this site

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: 2022/8/9 06:53,
TOP NEW HELP FIND: 
3.236.225.157:LOG IN

 ©2022 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>

After you find an appropriate page, you are invited to your to this massmind site! (posts will be visible only to you before review) Just type a nice message (short messages are blocked as spam) in the box and press the Post button. (HTML welcomed, but not the <A tag: Instead, use the link box to link to another page. A tutorial is available Members can login to post directly, become page editors, and be credited for their posts.


Link? Put it here: 
if you want a response, please enter your email address: 
Attn spammers: All posts are reviewed before being made visible to anyone other than the poster.
Did you find what you needed?

  PICList 2022 contributors:
o List host: MIT, Site host massmind.org, Top posters @20220809
* 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.
 

Welcome to www.piclist.com!

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  .