Promotic

Status - property of the AdoRecordset object

Description:
Returns the status of the current record with regard to batch updates or other bulk operations.
 
the property returns one or more RecordStatusEnum values that specifies the status of the current record with regard to batch updates or other bulk operations.
Syntax:
Byte Status
Values:
0 - adRecOK Record successfully updated.
0x1 - adRecNew Record is new.
0x2 - adRecModified Record modified.
0x4 - adRecDeleted Record deleted.
0x8 - adRecUnmodified Record not modified.
0x10 - adRecInvalid Record not saved, invalid bookmark.
0x40 - adRecMultipleChanges Record not saved, would have affected multiple records.
0x80 - adRecPendingChanges Record not saved, refers to a pending insert.
0x100 - adRecCanceled Record not saved, operation was canceled.
0x400 - adRecCantRelease New record not saved, existing record was locked.
0x800 - adRecConcurrencyViolation Record not saved, optimistic concurrency was in use.
0x1000 - adRecIntegrityViolation Record not saved, user violated integrity constraints.
0x2000 - adRecMaxChangesExceeded Record not saved, too many pending changes.
0x4000 - adRecObjectOpen Record not saved, conflict with an open storage object.
0x8000 - adRecOutOfMemory Record not saved, computer has run out of memory.
0x10000 - adRecPermissionDenied Record not saved, user has insufficient permissions.
0x20000 - adRecSchemaViolation Record not saved, violates the structure of the database.
0x40000 - adRecDBDeleted Record already deleted from the data source.
Note:
Property access for read only.
See also:
- AdoRecordset.AbsolutePosition (property)
Example:
JavaScriptVBScriptSelect and copy to clipboard

var nStatus = oRs.Status;
PROMOTIC 9.0.27 SCADA system documentation MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r.o.