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.