ADO 2.8 API Reference
Appends an object to a collection. If the collection is Fields, a new Field object may be created before it is appended to the collection.
fields.Append Name, Type, DefinedSize, Attrib, FieldValue
A collection object.
A Fields collection.
An object variable that represents the object to be appended.
A String value that contains the name of the new Field object, and must not be the same name as any other object in fields.
A DataTypeEnum value, whose default value is adEmpty, that specifies the data type of the new field. The following data types are not supported by ADO, and should not be used when appending new fields to a Recordset: adIDispatch, adIUnknown, adVariant.
Optional. A Long value that represents the defined size, in characters or bytes, of the new field. The default value for this parameter is derived from Type. Fields with a DefinedSize greater than 255 bytes, and treated as variable length columns. (The default DefinedSize is unspecified.)
Optional. A FieldAttributeEnum value, whose default value is adFldDefault, that specifies attributes for the new field. If this value is not specified, the field will contain attributes derived from Type.
Optional. A Variant that represents the value for the new field. If not specified, then the field is appended with a null value.