ADO » Recordset » Status
- Syntax:
- RecordStatusEnum = recordsetobject.Status
Returns a sum of one or more RecordStatusEnum values describing the status of the current record.
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 |
Examples
Code:
rsGuruChants.MoveFirst
Do While Not rsGuruChants.EOF
If rsGuruChants.Status = adRecModified Then
Response.Write rsChants("ChantTitle") & VBCRLF
End If
rsGuruChants.MoveNext
Loop
See Also:
