ADO: ActiveX Data Objects

Name

Field.AppendChunk — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

                     field.AppendChunk Data
                  

The AppendChunk method is used to append data to a large data or binary field.

Arguments

Data (Variant)

Contains the large amount of data that you wish to append to the current Field object.

Description

The AppendChunk method appends large amounts of either text or binary data to an existing Field object. This can come in very useful when the current system contains limited system memory with regard to the amount needed for the operation to be performed. With the AppendChunk method, you can add the data to your Field object in increments as you see fit.

You can use the AppendChunk method with a Field object only if the adFldLong bit of the Arguments property of that Field object is set to True.

By calling the AppendChunk method for the first time, you overwrite any data that may already be in that field. With each additional call to the AppendChunk method, the data is appended to the end of the pre-existing data. ADO assumes that you are finished appending to a particular field in a recordset if you then read or write data in another field in the same recordset. What this means is that if you call the AppendChunk method again on the original field, the data is once again cleared, as if it were the first call to the method. Reading or writing data in another Recordset object will not cause this action to occur, unless it is a clone of the original Recordset object.

See Also

Field.Attributes Property, FieldAttributeEnum ...