WinBatch Tech Support Home

Database Search

If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.

TechHome

WinBatch
OLE COM ADO CDO ADSI LDAP
ADO DAO
plus
ADSI LDAP CDO
plus
Samples from Users

Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.

ADO/DAO Constants 

Keywords: 	 ADO/DAO Constants reference
The following reference for constant values may be helpful to some. Use for DAO (Data Access Objects) or ADO (Active Data Objects). 
;ado value      constant                 refers to
adBigInt           = 20   ;Indicates an eight-byte signed integer (DBTYPE_I8).
adBinary           = 128  ;Indicates a binary value (DBTYPE_BYTES).
adBoolean          = 11   ;Indicates a boolean value (DBTYPE_BOOL).
adBSTR             = 8    ;Indicates a null-terminated character string (Unicode) (DBTYPE_BSTR).
adChapter          = 136  ;Indicates a four-byte chapter value that identifies rows in a child rowset (DBTYPE_HCHAPTER).
adChar             = 129  ;Indicates a string value (DBTYPE_STR).
adCurrency         = 6    ;Indicates 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    ;Indicates 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  ;Indicates a date value (yyyymmdd) (DBTYPE_DBDATE).
adDBTime           = 134  ;Indicates a time value (hhmmss) (DBTYPE_DBTIME).
adDBTimeStamp      = 135  ;Indicates a date/time stamp (yyyymmddhhmmss plus a fraction in billionths) (DBTYPE_DBTIMESTAMP).
adDecimal          = 14   ;Indicates an exact numeric value with a fixed precision and scale (DBTYPE_DECIMAL).
adDouble           = 5    ;Indicates a double-precision floating-point value (DBTYPE_R8).
adEmpty            = 0    ;Specifies no value (DBTYPE_EMPTY).
adError            = 10   ;Indicates a 32-bit error code (DBTYPE_ERROR).
adFileTime         = 64   ;Indicates a 64-bit value representing the number of 100-nanosecond intervals since January 1, 1601 (DBTYPE_FILETIME).
adGUID             = 72   ;Indicates a globally unique identifier (GUID) (DBTYPE_GUID).
adIDispatch        = 9    ;Indicates a pointer to an IDispatch interface on a COM object (DBTYPE_IDISPATCH).
                          ;This data type is currently not supported by ADO. Usage may cause unpredictable results.
adInteger          = 3    ;Indicates a four-byte signed integer (DBTYPE_I4).
adIUnknown         = 13   ;Indicates a pointer to an IUnknown interface on a COM object (DBTYPE_IUNKNOWN).
                          ;This data type is currently not supported by ADO. Usage may cause unpredictable results.
adLongVarBinary    = 205  ;Indicates a long binary value (Parameter object only).
adLongVarChar      = 201  ;Indicates a long string value (Parameter object only).
adLongVarWChar     = 203  ;Indicates a long null-terminated Unicode string value (Parameter object only).
adNumeric          = 131  ;Indicates an exact numeric value with a fixed precision and scale (DBTYPE_NUMERIC).
adPropVariant      = 138  ;Indicates an Automation PROPVARIANT (DBTYPE_PROP_VARIANT).
adSingle           = 4    ;Indicates a single-precision floating-point value (DBTYPE_R4).
adSmallInt         = 2    ;Indicates a two-byte signed integer (DBTYPE_I2).
adTinyInt          = 16   ;Indicates a one-byte signed integer (DBTYPE_I1).
adUnsignedBigInt   = 21   ;Indicates an eight-byte unsigned integer (DBTYPE_UI8).
adUnsignedInt      = 19   ;Indicates a four-byte unsigned integer (DBTYPE_UI4).
adUnsignedSmallInt = 18   ;Indicates a two-byte unsigned integer (DBTYPE_UI2).
adUnsignedTinyInt  = 17   ;Indicates a one-byte unsigned integer (DBTYPE_UI1).
adUserDefined      = 132  ;Indicates a user-defined variable (DBTYPE_UDT).
adVarBinary        = 204  ;Indicates a binary value (Parameter object only).
adVarChar          = 200  ;Indicates a string value (Parameter object only).
adVariant          = 12   ;Indicates an Automation Variant (DBTYPE_VARIANT).
                          ;This data type is currently not supported by ADO. Usage may cause unpredictable results.
adVarNumeric       = 139  ;Indicates a numeric value (Parameter object only).
adVarWChar         = 202  ;Indicates a null-terminated Unicode character string (Parameter object only).
adWChar            = 130  ;Indicates a null-terminated Unicode character string (DBTYPE_WSTR).

;other values   constant  ;DAO constants for how RecordSet is Open
dbUseJet           = 2
dbUseODBC          = 1
dbOpenDynamic      = 16 (&H10)
dbOpenDynaset      = 2
dbOpenForwardOnly  = 8
dbOpenSnapshot     = 4
dbOpenTable        = 1
dbAppendOnly       = 8
dbSQLPassThrough   = 64 (&H40)
dbSeeChanges       = 512 (&H200)
dbDenyRead         = 2
dbDenyWrite        = 1
dbForwardOnly      = 256 (&H100)
dbReadOnly         = 4
dbRunAsync         = 1024 (&H400)
dbExecDirect       = 2048 (&H800)
dbConsistent       = 32 (&H20)
dbInconsistent     = 16 (&H10)

;other values   constant  ;ACCESS constants for TransferDatabase()
acLink             = 2
acImport           = 0
acExport           = 1

;other values   constant  ;ACCESS constants for Object Types
acTable            = 0
acReport           = 3
acModule           = 5
acMacro            = 4
acForm             = 2

Article ID:   W14568

Filename:   ADO - DAO Constants.txt
File Created: 2002:11:15:11:33:34
Last Updated: 2002:11:15:11:33:34