Type Property - ADO

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

Applies To

Field, Parameter, Property

Required Files

msado15.dll
VC: adoint.h, adoid.h

Settings and Return Values

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

Remarks

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

Examples

Tye Property Example (VB)

© 1997 Microsoft Corporation. All rights reserved. Terms of Use.