ADO: ActiveX Data Objects

Name

Field.Status Property — (Versions 2.5, 2.6)

Synopsis

                     status = field.Type

The Status property indicates the status of the current Field object.

Datatype

FieldStatusEnum

Description

The default value for the Status property is adFieldOK.

After a call to the Record or Recordset’s Update method if an error has occurred the Status property of each Field object is set to a value from the FieldStatusEnum enumeration, describing the problem.

If you are adding and deleting Field objects to and from the Fields collection, the Status property can tell you whether they have been successfully added or deleted.

The Status property can hold more than one FieldStatusEnum enumeration value at a time.

See Also

FieldStatusEnum Enumeration, Record.Update Method, Recordset.Update Method