ADO » Field » Attributes
- Syntax:
- long = fieldobject.Attributes
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.
Examples
Code:
If (objField.attributes
= adFldUnknownUpdatable) Then
Response.Write "Provider cannot determine
if you can write to the field"
End If
See Also:
