Attributes Property (ADO)

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

Indicates that the parameter accepts signed values. (Default.)

adParamNullable

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

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

Indicates that you can write to the field.

adFldUnknownUpdatable

Indicates that the provider cannot determine if you can write to the field.

adFldFixed

Indicates that the field contains fixed-length data.

adFldIsNullable

Indicates that the field accepts Null values.

adFldMayBeNull

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

Indicates that the property is not supported by the provider.

adPropRequired

Indicates that the user must specify a value for this property before the data source is initialized.

adPropOptional

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.

Attributes Property

Settings and Return Values

Remarks

Applies To

See Also