Purpose
All the values of the DataType Enum:
The type of action to be performed when SetPermissions is called.
Prototype
FUNCTION AdoDataTypeEnum ( ) AS ARRAY
Return
ARRAY Every row in this array has 2 values:
• The numeric value of the Enum value
• A text representation of this value
This array can be used to validate values, and to print a meaningful description of the values during debugging You can pass this array to the AdoEnum2Str() function to convert the value of an Enum to a string
Description
List of possible values
| adBigInt | 20 An eight-byte signed integer (DBTYPE_I8). |
| adBinary | 128 A binary value (DBTYPE_BYTES). |
| adBoolean | 11 A Boolean value (DBTYPE_BOOL). |
| adBSTR | 8 A null-terminated character string (Unicode) (DBTYPE_BSTR). |
| adChapter | 136 A four-byte chapter value used to identify rows in a child rowset (DBTYPE_HCHAPTER). |
| adChar | 129 A String value (DBTYPE_STR). |
| adCurrency | 6 A currency value (DBTYPE_CY). Currency is a fixed-point number with four digits to the right of the decimal point. It is stored in an eight-byte signed integer scaled by 10,000. |
| adDate | 7 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 | 133 A date value (yyyymmdd) (DBTYPE_DBDATE). |
| adDBTime | 134 A time value (hhmmss) (DBTYPE_DBTIME). |
| adDBTimeStamp | 135 A date-time stamp (yyyymmddhhmmss plus a fraction in billionths) (DBTYPE_DBTIMESTAMP). |
| adDecimal | 14 An exact numeric value with a fixed precision and scale (DBTYPE_DECIMAL). |
| adDouble | 5 A double-precision floating- point value (DBTYPE_R8). |
| adEmpty | 0 Specifies no value was specified (DBTYPE_EMPTY). |
| adError | 10 A 32-bit error code (DBTYPE_ERROR). |
| adFileTime | 64 A 64-bit value representing the number of 100-nanosecond intervals since January 1, 1601 (DBTYPE_FILETIME). |
| adGUID | 72 A globally unique identifier (GUID) (DBTYPE_GUID). |
| adIDispatch | 9 A pointer to an IDispatch interface on an OLE object (DBTYPE_IDISPATCH). |
| Note This data type is currently not supported by ADO. Usage may cause unpredictable results. |
| adInteger | 3 A 4-byte signed integer (DBTYPE_I4). |
| adIUnknown | 13 A pointer to an IUnknown interface on an OLE object (DBTYPE_IUNKNOWN). |
| Note This data type is currently not supported by ADO. Usage may cause unpredictable results. |
| 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 (DBTYPE_NUMERIC). |
| adPropVariant | 138 An Automation PROPVARIANT (DBTYPE_PROP_VARIANT). |
| adSingle | 4 A single-precision floating- point value (DBTYPE_R4). |
| adSmallInt | 2 A two-byte signed integer (DBTYPE_I2). |
| adTinyInt | 16 A 1-byte signed integer (DBTYPE_I1). |
| adUnsignedBigInt | 21 An 8-byte unsigned integer (DBTYPE_UI8). |
| adUnsignedInt | 19 A 4-byte unsigned integer (DBTYPE_UI4). |
| adUnsignedSmallInt | 18 A 2-byte unsigned integer (DBTYPE_UI2). |
| adUnsignedTinyInt | 17 A 1-byte unsigned integer (DBTYPE_UI1). |
| adUserDefined | 132 A user-defined variable (DBTYPE_UDT). |
| adVarBinary | 204 A binary value (Parameter object only). |
| adVarChar | 200 A String value (Parameter object only). |
| adVariant | 12 An Automation Variant (DBTYPE_VARIANT). |
| Note This data type is currently not supported by ADO. Usage may cause unpredictable results. |
| adVarNumeric | 139 A numeric value (Parameter object only). |
| adVarWChar | 202 A null-terminated Unicode character string (Parameter object only). |
| adWChar | 130 A null-terminated Unicode character string (DBTYPE_WSTR). |
See Also
Enums, AdoEnum2Str(), AdoStr2Enum()
