Attributes Property - ADO

Indicates one or more characteristics of an object.

Applies To

Connection, Field, Parameter, Property

Required Files

msado15.dll
VC: adoint.h, adoid.h

Settings and Return Values

Sets or returns a Long value.

For a Connection object, the value can be a sum of any one or more of these XactAttributeEnum values (default is zero):

Constant Value Description
adXactCommitRetaining 131072 Performs retaining commits, that is, calling CommitTrans automatically starts a new transaction. Not all providers will support this.
adXactAbortRetaining 262144 Performs retaining aborts, that is, calling RollbackTrans automatically starts a new transaction. Not all providers will support this.

For a Parameter object, the value can be a sum of any one or more of these ParameterAttributesEnum values:

Constant Value Description
adParamSigned 16 Indicates that the parameter accepts signed values. (Default.)
adParamNullable 64 Indicates that the parameter accepts Null values.
adParamLong 128 Indicates that the parameter accepts long binary data.

For a Field object, the value specifies characteristics of the field and can be a sum of any one or more of these FieldAttributeEnum values:

Constant Value Description
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.
adFldUpdatable 4 Indicates that you can write to the field.
adFldUnknownUpdatable 8 Indicates that the provider cannot determine if you can write to the field.
adFldFixed 16 Indicates that the field contains fixed-length data.
adFldIsNullable 32 Indicates that the field accepts Null values.
adFldMayBeNull 64 Indicates that you can read Null values from the field.
adFldLong 128 Indicates that the field is a long binary field. Also indicates that you can use the AppendChunk and GetChunk methods.
adFldRowID 256 Indicates that the field contains some kind of record ID (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.
adFldCacheDeferred 4096 Indicates that the provider caches field values and that subsequent reads are done from the cache.

For a Property object, the value can be a sum of any one or more of these PropertyAttributesEnum values:

Constant Value Description
adPropNotSupported 0 Indicates that the property is not supported by the provider.
adPropRequired 1 Indicates that the user must specify a value for this property before the data source is initialized.
adPropOptional 2 Indicates that the user does not need to specify a value for this property before the data source is initialized.
adPropRead 512 Indicates that the user can read the property.
adPropWrite 1024 Indicates that the user can set the property.

Remarks

Use the Attributes property to set or return characteristics of Connection objects, Parameter objects, Field objects, or Property objects.

For Connection objects, the Attributes property is read/write.

For Parameter objects, the Attributes property is read/write. For Field and Property objects, the Attributes property is read-only.

When you set multiple attributes, you can sum the appropriate constants. If you set the property value to a sum including incompatible constants, an error occurs.

Examples

Attributes, Name Properties Example (VB)

© 1997 Microsoft Corporation. All rights reserved. Terms of Use.