Indicates the operational type or data type of a Parameter, Field, or Property object.
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 |
For Parameter objects, the Type property is read/write. For all other objects, the Type property is read-only.