Returns a long value that is the sum of one or more FieldAttributeEnum valuesthat define the characteristics of a Field object.
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
|
Note: This code only works if one attribute is set, otherwise it always returns false.
|