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
|
adDBTime (DBTIME) |
134 (&H86) |
Indicates a time value in the form of
|
adDBTimeStamp (DBTIMESTAMP) |
135 (&H87) |
Indicates a date/time stamp in the form of
|
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.
