Attributes Property

Indicates one or more characteristics of an object.

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.

Applies To

Connection, Field, Parameter, Property

See Also

AppendChunk, BeginTrans, CommitTrans, RollbackTrans, GetChunk