Sun
ONE Active Server Pages Product Home Page Developer Site Version
 

ContentsPreviousNextIndex



ADO Parameter Object Type Property

The operational type or data type of a Parameter object.

Type Property Return Values (ADO Parameter Object)

Sets or returns one of the following DataTypeEnum values. The corresponding OLE DB type indicators are as follows:

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.
adLongVarChar
A long String value.
adLongVarWChar
A long null-terminated string value.
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.
adVarChar
A String value.
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.
adWChar
A null-terminated Unicode character string (DBTYPE_WSTR).

Type Property Remarks (ADO Parameter Object)

For Parameter objects, the Type property is read/write.



ContentsPreviousNextIndex