CancelBatch Method Resync Method UpdateBatch Method Filter Property PROPERTY:  Recordset::Status RecordStatusEnum = recordsetobject.Status The Status property returns one or more of the RecordStatusEnum constants that describe the status of the current record when it is subject to batch operations such as CancelBatch, Resync, or UpdateBatch. You can use this property to determine if an operation performed on a particular record failed or succeeded. RecordStatusEnum Constants Constant Value Description adRecCanceled 0x100 Operation canceled and record not saved adRecCantRelease 0x400 Cannot save new record because existing record is locked adRecConcurrencyViolation 0x800 Optimistic concurrency in effect, record not saved adRecDBDeleted 0x40000 Record has already been deleted adRecDeleted 0x4 Record was successfully deleted adRecIntegrityViolation 0x1000 Integrity constraints violation, record not saved adRecInvalid 0x10 Bookmark is invalid, record not saved adRecMaxChangesExceeded 0x2000 Too many pending changes, record not saved adRecModified 0x2 Record was modified adRecMultipleChanges 0x40 Record not saved because it would have affected other records adRecNew 0x1 New record adRecObjectOpen 0x4000 Conflict with open storage object, record not saved adRecOK 0 Record was successfuly updated adRecOutOfMemory 0x8000 Computer out of memory, record not saved adRecPendingChanges 0x80 Due to pending insert, record not changed adRecPermissionDenied 0x10000 User does not have permissions adRecSchemaViolation 0x20000 Violation of underlying database, record not saved adRecUnmodified 0x8 Record has not been changed   Code (VBScript): rsGuruChants.MoveFirst Do While Not rsGuruChants.EOF    If rsGuruChants.Status = adRecModified Then       Response.Write rsChants("ChantTitle") & VBCRLF    End If    rsGuruChants.MoveNext Loop Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information