ADO 2.7 Field type constants and their values

Back ] Development Home ] Next ]

Field Type Constant Name Value Description
adFldCacheDeferred 4096 Indicates that the provider caches field values and that subsequent reads are done from the cache.
adFldFixed 16 Indicates that the field contains fixed-length data.
adFldIsChapter 8192 Indicates that the field contains a chapter value, which specifies a specific child recordset related to this parent field. Typically chapter fields are used with data shaping or filters.
adFldIsCollection 262144 Indicates that the field specifies that the resource represented by the record is a collection of other resources, such as a folder, rather than a simple resource, such as a text file.
adFldIsDefaultStream 131072 Indicates that the field contains the default stream for the resource represented by the record. For example, the default stream can be the HTML content of a root folder on a Web site, which is automatically served when the root URL is specified.
adFldIsNullable 32 Indicates that the field accepts null values.
adFldIsRowURL 65536 Indicates that the field contains the URL that names the resource from the data store represented by the record.
adFldLong 128 Indicates that the field is a long binary field. Also indicates that you can use the AppendChunk and GetChunk methods.
adFldMayBeNull 64 Indicates that you can read null values from the field.
adFldMayDefer 2 Indicates that the field is deferred—that is, the field values are not retrieved from the data source with the whole record, but only when you explicitly access them.
adFldNegativeScale 16384 Indicates that the field represents a numeric value from a column that supports negative scale values. The scale is specified by the NumericScale property.
adFldRowID 256 Indicates that the field contains a persistent row identifier that cannot be written to and has no meaningful value except to identify the row (such as a record number, unique identifier, and so forth).
adFldRowVersion 512 Indicates that the field contains some kind of time or date stamp used to track updates.
adFldUnknownUpdatable 8 Indicates that the provider cannot determine if you can write to the field.
adFldUpdatable 4 Indicates that you can write to the field.
adFldUnspecified -1 Indicates that the provider does not specify the field attributes.
 

Back ] Development Home ] Next ]

Questions? Use the MAIN PAGE anonymous FORM. And ask Away