ADO Parameter Object AppendChunk Method

You are here: ADO Component Reference > ADO Objects > ADO Parameter Object > ADO Parameter Object Methods > ADO Parameter Object AppendChunk Method

ADO Parameter Object AppendChunk Method

Appends data to a large text or binary data Parameter object.

AppendChunk Method Syntax (ADO Parameter Object)

object.AppendChunk Data

AppendChunk Method Parameters (ADO Parameter Object)

object

A Parameter object.

Data

A Variant containing the data you want to append to the object.

AppendChunk Method Remarks (ADO Parameter Object)

Use the AppendChunk method on a Parameter object to fill it with long binary or character data. In situations where system memory is limited, you can use the AppendChunk method to manipulate long values in portions rather than in their entirety.

If the adFldLong bit in the ADO Parameter Object Attributes Property of a Parameter object is set to True, you can use the AppendChunk method for that parameter.

The first AppendChunk call on a Parameter object writes data to the parameter, overwriting any existing data. Subsequent AppendChunk calls on a Parameter object adds to existing parameter data. An AppendChunk call that passes a Null value generates an error; you must manually set the ADO Parameter Object Value Property of the Parameter object to a zero-length string ("") in order to clear its value.