Name

DataTypeEnum Enumeration — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

The DataTypeEnum enumeration indicates the datatype of the particular parameter, field, or property.

Table E-16. DataTypeEnum Enumeration Values

Enumeration (ADO/WFC)

Value

Description

adArray (ARRAY)
8192 (&H2000)

Indicates an array of values. This value is always combined with another DataTypeEnum enumeration value.

adBigInt (BIGINT)
20 (&H14)

Indicates an 8-byte signed integer.

adBinary (BINARY)
128 (&H80)

Indicates a binary value.

adBoolean (BOOLEAN)
11

Indicates a Boolean value (True or False).

adBSTR (BSTR)
8

Indicates a null-terminated character Unicode string.

adChapter (CHAPTER)
136 (&H88)

Indicates a 4-byte Chapter recordset (for hierarchical recordsets).

adChar (CHAR)
129 (&H81)

Indicates a String value.

adCurrency (CURRENCY)
6

Indicates a currency value that is an 8-byte signed integer with a scale factor of 10,000.

adDate (DATE)
7

Indicates a Date value stored as a Double, where the whole part is the number of days since December 30, 1899, and the fraction represents the time of day.

adDBDate (DBDATE)
133 (H&85)

Indicates a date value in the form of yyyymmdd.

adDBTime (DBTIME)
134
(&H86)

Indicates a time value in the form of hhmmss.

adDBTimeStamp (DBTIMESTAMP)
135
(&H87)

Indicates a date/time stamp in the form of yyyymmddhhmmss, including a fraction in billionths.

adDecimal (DECIMAL)
14

Indicates an exact numeric value with a fixed-precision and scale factor. ...

Get ADO: ActiveX Data Objects now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.