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()