ADO: ActiveX Data Objects

Name

Command.State Property — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

                     state = command.State

The Status property is used to determine the status of the current record when using batch updates or bulk operations.

Datatype

RecordStatusEnum

Description

The Type property is used to check the changes that are pending for records that have changed during a batch update. In addition, you can check the status of records that have failed during bulk operations such as what might happen with a call to the Delete, Resync, UpdateBatch, or CancelBatch methods or when a Filter property is set to an array of bookmarks.

The Type property returns a sum of one or more of the RecordStatusEnum enumerations, listed in Appendix E .

See Also

Recordset.CancelBatch, Recordset.Delete Method, Recordset.Filter Property, Recordset.Resync Method, Recordset.UpdateBatch, RecordStatusEnum Enumeration, ObjectStateEnum Enumeration