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. ... |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access