|
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
|
