Indicates the operational type or data type of a Parameter, Field, or Property object.
Applies To
Required Files
msado15.dll
VC: adoint.h, adoid.h
Settings and Return Values
Sets or returns one of the following DataTypeEnum values:
| Constant | Value | Description |
| adBigInt | 20 | An 8-byte signed integer |
| adBinary | 128 | A binary value |
| adBoolean | 11 | A Boolean value |
| adBSTR | 8 | A null-terminated character string (Unicode) |
| adChar | 129 | A String value |
| adCurrency | 6 | A currency value (8-byte signed integer scaled by 10,000) |
| adDate | 7 | A Date value |
| adDBDate | 133 | A date value (yyyymmdd) |
| adDBTime | 134 | A time value (hhmmss) |
| adDBTimeStamp | 135 | A date-time stamp (yyyymmddhhmmss plus a fraction in billionths) |
| adDecimal | 14 | An exact numeric value with a fixed precision and scale |
| adDouble | 5 | A double-precision floating point value |
| adEmpty | 0 | No value was specified |
| adError | 10 | A 32-bit error code |
| adGUID | 72 | A globally unique identifier (GUID) |
| adIDispatch | 9 | A pointer to an IDispatch interface on an OLE object |
| adInteger | 3 | A 4-byte signed integer |
| adIUnknown | 13 | A pointer to an IUnknown interface on an OLE object |
| adLongVarBinary | 205 | A long binary value (Parameter object only) |
| adLongVarChar | 201 | A long String value (Parameter object only) |
| adLongVarWChar | 203 | A long null-terminated string value (Parameter object only) |
| adNumeric | 131 | An exact numeric value with a fixed precision and scale |
| adSingle | 4 | A single-precision floating point value |
| adSmallInt | 2 | A 2-byte signed integer |
| adTinyInt | 16 | A 1-byte signed integer |
| adUnsignedBigInt | 21 | An 8-byte unsigned integer |
| adUnsignedInt | 19 | A 4-byte unsigned integer |
| adUnsignedSmallInt | 18 | A 2-byte unsigned integer |
| adUnsignedTinyInt | 17 | A 1-byte unsigned integer |
| adUserDefined | 132 | A user-defined variable |
| adVarBinary | 204 | A binary value (Parameter object only) |
| adVarChar | 200 | A String value (Parameter object only) |
| adVariant | 12 | An OLE Automation Variant |
| adVarWChar | 202 | A null-terminated Unicode character string (Parameter object only) |
| adWChar | 130 | A null-terminated Unicode character string |
Remarks
For Parameter objects, the Type property is read/write. For all other objects, the Type property is read-only.
Examples
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.