ADO: ActiveX Data Objects

Name

Parameter.AppendChunk Method — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

                     parameter.AppendChunk Data
                  

The AppendChunk method appends data to a large data or binary field within the current Parameter object.

Arguments

Data

The only parameter, Data, is a Variant datatype that contains the large amount of data that you wish to append to the current Parameter object.

Description

The AppendChunk method appends large amounts of either text or binary data to an existing Parameter object. This can be very useful when the current system contains limited system memory in respect 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.

The adFldLong bit of the Arguments property belonging to the Parameter object must be set in order for the AppendChunk method of the Parameter object to be called.

By calling the AppendChunk method multiple times on a Parameter object, you append the data to the pre-existing data in the object. The only way to clear the data in a Parameter object is set it to a zero-length string. By passing a Null value to the AppendChunk method of a Parameter object, you generate an error.

See Also

Parameter.Arguments Property