You can use the AppendChunk method for a Field
object if the Attributes property is set to adFldLong. First
time you call the AppendChunk method on a Field object it
overwrites any existing data. The next AppendChunk calls add
data to existing data. If you append data to one field and then
set or read the value of another field in the current record,
ADO assumes that you are finished appending data to the first
field. If you then call the AppendChunk method on the first
field again, ADO will overwrite the existing data. Accessing
fields in other Recordset objects that are not clones of the
first Recordset object will not disrupt AppendChunk operations.
There must be a current record when you call the AppendChunk
method on a Field object.
Note: This method does not work on Field objects of a
Record object. |