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

Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information