ADO » Fields » Append

Fields.Append Name, Type, DefineSize, Attrib, FieldValue
The optional Name is the unique name of the new Field object being appended to the collection.
The optional Type is one of the DataTypeEnum constants that defines the data type of the new Field.
The optional DefinedSize parameter is a long value that is the size in bytes or characters of the new Field. When DefinedSize exceeds 255 bytes, the field is treated as having variable length columns.
The optional Attrib parameter is one of the FieldAttributeEnum constants that specify the attributes of the new Field.
The optional FieldValue parameter is a variant that is the value for the new Field. If this parameter is not provided, it will be set to null when the new Field is appended.

The Append method is used to add (append) a Field object to the Fields Collection.

Using this method, you can both append and assign a value to the object at the same time. This is useful, because the Value property must first be set and an Update must have occured, before you can set any other properties. There are three data types for the Field object that cannot be appended to the Fields Collection. If you try to use adArray, adChapter, or adEmpty, an error will occur.

This method has five optional parameters.
DataTypeEnum Constants

Constant Value Description
adArray 0x2000 Combine with another data type to indicate that the other data type is an array
adBigInt 20 8-byte signed integer
adBinary 128 Binary
adBoolean 11 True or false Boolean
adBSTR 8 Null-terminated character string
adChapter 136 4-byte chapter value for a child recordset
adChar 129 String
adCurrency 6 Currency format
adDate 7 Number of days since 12/30/1899
adDBDate 133 YYYYMMDD date format
adDBTime 134 HHMMSS time format
adDBTimeStamp 135 YYYYMMDDHHMMSS date/time format
adDecimal 14 Number with fixed precision and scale
adDouble 5 Double precision floating-point
adEmpty 0 no value
adError 10 32-bit error code
adFileTime 64 Number of 100-nanosecond intervals since 1/1/1601
adGUID 72 Globally unique identifier
adIDispatch 9 Currently not supported by ADO
adInteger 3 4-byte signed integer
adIUnknown 13 Currently not supported by ADO
adLongVarBinary 205 Long binary value
adLongVarChar 201 Long string value
adLongVarWChar 203 Long Null-terminates string value
adNumeric 131 Number with fixed precision and scale
adPropVariant 138 PROPVARIANT automation
adSingle 4 Single-precision floating-point value
adSmallInt 2 2-byte signed integer
adTinyInt 16 1-byte signed integer
adUnsignedBigInt 21 8-byte unsigned integer
adUnsignedInt 19 4-byte unsigned integer
adUnsignedSmallInt 18 2-byte unsigned integer
adUnsignedTinyInt 17 1-byte unsigned integer
adUserDefined 132 User-defined variable
adVarBinary 204 Binary value
adVarChar 200 String
adVariant 12 Automation variant
adVarNumeric 139 Variable width exact numeric with signed scale
adVarWChar 202 Null-terminated Unicode character string
adWChar 130 Null-terminated Unicode character string

FieldAttributeEnum Constants
Constant Value Description
adFldCacheDeferred 0x1000 Provider caches values and reads from cache
adFldFixed 0x10 Fixed-length data
adFldIsChapter 0x2000 Chapter value with specified child recordset
adFldIsCollection 0x40000 Collection of resources
adFldIsDefaultStream 0x20000 Contains default stream
adFldIsNullable 0x20 Accepts null values
adFldIsRowURL 0x10000 Contains URL to resource in data source
adFldKeyColumn 0x8000 Primary key or part of primary key
adFldLong 0x80 Long binary field and can use AppendChunk and GetChunk methods
adFldMayBeNull 0x40 Can read null values
adFldMayDefer 0x2 Values are not retrieved with whole record
adFldNegativeScale 0x4000 Can support negative scale values
adFldRowID 0x100 Contains a row identifier used only to ID the row
adFldRowVersion 0x200 Uses time/date to track updates
adFldUnknownUpdatable 0x8 Provider cannot determine if you can write to field
adFldUnspecified -1 Does not specify attributes
adFldUpdatable 0x4 Can write to field


objRecord.Fields.Append "Age", adInteger