DevGuru ADO Field::Attributes Property

Quick References

Features

Partners

PROPERTY: Field::Attributes

long = fieldobject.Attributes

The Attributes property returns a long value that is the sum of one or more FieldAttributeEnum constants that indicate the characteristics of a Field object. The default is zero.

The Attributes property has read/write permission when being used to create recordsets, but converts to read-only when you open an already created recordset.

Not all providers support this property.

FieldAttributeEnum Constants

Constant	Value	Description
adFldCacheDeferred	0x1000	Provider caches values and reads from cache
adFldFixed	0x10	Fixed-length data
adFldIsChapter	0x2000	Chapter value with specified child recordset
adFldIsCollection	0x40000	Collection of resources
adFldIsDefaultStream	0x20000	Contains default stream
adFldIsNullable	0x20	Accepts null values
adFldIsRowURL	0x10000	Contains URL to resource in data source
adFldKeyColumn	0x8000	Primary key or part of primary key
adFldLong	0x80	Long binary field and can use AppendChunk and GetChunk methods
adFldMayBeNull	0x40	Can read null values
adFldMayDefer	0x2	Values are not retrieved with whole record
adFldNegativeScale	0x4000	Can support negative scale values
adFldRowID	0x100	Contains a row identifier used only to ID the row
adFldRowVersion	0x200	Uses time/date to track updates
adFldUnknownUpdatable	0x8	Provider cannot determine if you can write to field
adFldUnspecified	-1	Does not specify attributes
adFldUpdatable	0x4	Can write to field

Code (VBScript):
If (objField.attributes = adFldUnknownUpdatable) Then
Response.Write "Provider cannot determine if you can write to the field"
End If

Note: This code only works if one attribute is set, otherwise it always returns false.