Type Property (ADO)

Contents  Index  Topic Contents

Type Property - ADO

Indicates the operational type or data type of a Parameter, Field, or Property object.

Applies To

Settings and Return Values

Sets or returns one of the following DataTypeEnum values. The corresponding OLE DB type indicator is shown in parentheses in the description column of the following table. For more information on OLE DB data types, see Chapter 10 and Appendix A of the OLE DB 1.1 Programmer's Reference.

Constant	Description

adArray	Or'd together with another type to indicate that the data is a safe-array of that type (DBTYPE_ARRAY).
adBigInt	An 8-byte signed integer (DBTYPE_I8).
adBinary	A binary value (DBTYPE_BYTES).
adBoolean	A Boolean value (DBTYPE_BOOL).
adByRef	Or'd together with another type to indicate that the data is a pointer to data of the other type (DBTYPE_BYREF).
adBSTR	A null-terminated character string (Unicode) (DBTYPE_BSTR).
adChar	A String value (DBTYPE_STR).
adCurrency	A currency value (DBTYPE_CY). Currency is a 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 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).
adDBTime	A time value (hhmmss) (DBTYPE_DBTIME).
adDBTimeStamp	A date-time stamp (yyyymmddhhmmss plus a fraction in billionths) (DBTYPE_DBTIMESTAMP).
adDecimal	An exact numeric value with a fixed precision and scale (DBTYPE_DECIMAL).
adDouble	A double-precision floating point value (DBTYPE_R8).
adEmpty	No value was specified (DBTYPE_EMPTY).
adError	A 32-bit error code (DBTYPE_ERROR).
adGUID	A globally unique identifier (GUID) (DBTYPE_GUID).
adIDispatch	A pointer to an IDispatch interface on an OLE object (DBTYPE_IDISPATCH).
adInteger	A 4-byte signed integer (DBTYPE_I4).
adIUnknown	A pointer to an IUnknown interface on an OLE object (DBTYPE_IUNKNOWN).
adLongVarBinary	A long binary value (Parameter object only).
adLongVarChar	A long String value (Parameter object only).
adLongVarWChar	A long null-terminated string value (Parameter object only).
adNumeric	An exact numeric value with a fixed precision and scale (DBTYPE_NUMERIC).
adSingle	A single-precision floating point value (DBTYPE_R4).
adSmallInt	A 2-byte signed integer (DBTYPE_I2).
adTinyInt	A 1-byte signed integer (DBTYPE_I1).
adUnsignedBigInt	An 8-byte unsigned integer (DBTYPE_UI8).
adUnsignedInt	A 4-byte unsigned integer (DBTYPE_UI4).
adUnsignedSmallInt	A 2-byte unsigned integer (DBTYPE_UI2).
adUnsignedTinyInt	A 1-byte unsigned integer (DBTYPE_UI1).
adUserDefined	A user-defined variable (DBTYPE_UDT).
adVarBinary	A binary value (Parameter object only).
adVarChar	A String value (Parameter object only).
adVariant	An Automation Variant (DBTYPE_VARIANT).
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).
adVarWChar	A null-terminated Unicode character string (Parameter object only).
adWChar	A null-terminated Unicode character string (DBTYPE_WSTR).

Remarks

For Parameter objects, the Type property is read/write. For all other objects, the Type property is read-only.

Examples