DataTypeEnum
Constant Description Value Jet 4.0
data
type
adArray Or'd together with another type to indicate that
the data is a safe-array of that type
(DBTYPE_ARRAY).
Not listed in the WROX Tables (2.0)
adBigInt An 8-byte signed integer (DBTYPE_I8). 20
adBinary A binary value (DBTYPE_BYTES). 128
adBoolean A Boolean value (DBTYPE_BOOL). 11
adByRef Or'd together with another type to indicate that
the data is a pointer to data of the other type
(DBTYPE_BYREF).
Not listed in the WROX Tables (2.0)
Not listed in the 2.6 table
adBSTR A null-terminated character string (Unicode) 8
(DBTYPE_BSTR).
adChapter A field which is a Child ADO RecordSet. 136
New w/v2.0
adChar A String value (DBTYPE_STR). 129
adCurrency A currency value (DBTYPE_CY). Currency is a 6
fixed-point number with 4 digits to the right of
the decimal point. It is stored in an 8-byte signed
integer
scaled by 10,000.
adDate A Date value (DBTYPE_DATE). A date is stored 7
as a Double, the whole part of which is the
number of days since December 30, 1899, and
the fractional part of which is the fraction of a
day.
adDBDate A date value (yyyymmdd) (DBTYPE_DBDATE). 133
adDBFileTime A database file time. 137
Not shown in ado2.6
adDBTime A time value (hhmmss) (DBTYPE_DBTIME). 134
adDBTimeStamp A date-time stamp (yyyymmddhhmmss plus a 135
fraction in billionths)
(DBTYPE_DBTIMESTAMP).
adDecimal An exact numeric value with a fixed precision 14
and scale (DBTYPE_DECIMAL).
adDouble A double-precision floating point value 5
(DBTYPE_R8).
adEmpty No value was specified (DBTYPE_EMPTY). 0
adError A 32-bit error code (DBTYPE_ERROR). 10
adFileTime A Dos/Win 32 file time. The number of 100 nano 64
second intervals since Jan 1, 1601.
adGUID A globally unique identifier (GUID) 72
(DBTYPE_GUID).
adIDispatch A pointer to an IDispatch interface on an OLE 9
object (DBTYPE_IDISPATCH).
adInteger A 4-byte signed integer (DBTYPE_I4). 3
adIUnknown A pointer to an IUnknown interface on an OLE 13
object (DBTYPE_IUNKNOWN).
adLongVarBinary A long binary value (Parameter object only). 205
adLongVarChar A long String value (Parameter object only). 201
adLongVarWChar A long null-terminated string value (Parameter 203 Memo
object only).
adNumeric An exact numeric value with a fixed precision 131
and scale (DBTYPE_NUMERIC).
adPropVariant A variant that is not equivalent to an Automation 138
variant.
New w/V2.0
adSingle A single-precision floating point value 4
(DBTYPE_R4).
adSmallInt A 2-byte signed integer (DBTYPE_I2). 2
adTinyInt A 1-byte signed integer (DBTYPE_I1). 16
adUnsignedBigInt An 8-byte unsigned integer (DBTYPE_UI8). 21
adUnsignedInt A 4-byte unsigned integer (DBTYPE_UI4). 19
adUnsignedSmallInt A 2-byte unsigned integer (DBTYPE_UI2). 18
adUnsignedTinyInt A 1-byte unsigned integer (DBTYPE_UI1). 17
adUserDefined A user-defined variable (DBTYPE_UDT). 132
adVarBinary A binary value (Parameter object only). 204
adVarChar A String value (Parameter object only). 200
adVariant An Automation Variant (DBTYPE_VARIANT). 12
adVarNumeric A variable width exact numeric, with a single 139
scale value.
New w/ADO v2.0
adVarWChar A null-terminated Unicode character string 202
(Parameter object only).
adVector Or'd together with another type to indicate that
the data is a DBVECTOR structure, as defined
by OLE DB, that contains a count of elements
and a pointer to data of the other type
(DBTYPE_VECTOR).
Not in ADO v2.0
A null-terminated Unicode character string 130 Text
Not in ADO 2.6 (DBTYPE_WSTR).
documentation
adWChar
The Direction parameter or the CreateParameter method of the Command class uses a
data type of ParamterDirectionEnum.
ParameterDirectionEnum can be one of the following
Name Type / Value Description
adParamUnknown 0 To indicate the direction of the parameter is unknown
adParamInput 1 The parameter is used as an input parameter.
adParamOutput 2 Parameter is an output parameter from the command.
adParamInputOutput 3 Parameter is both an input and an output.
adParamReturnValue 4 Parameter is a return value from the command.
