Appends data to a large text or binary data Field or Parameter object.
Syntax
{field | parameter}.AppendChunk Data
The AppendChunk method syntax has these parts.
Part |
Description |
field |
An object variable representing a Field object in the Fields collection of an open Recordset object. |
parameter |
An object variable representing a Parameter object in the Parameters collection of a Command object. |
Data |
A Variant containing the data you want to append to field or parameter. |
Remarks
Use the AppendChunk method on a Field or 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.
Field
The presence of the adFldLong constant in the Attributes property of a Field object indicates that you can use the AppendChunk method for that field.
The first AppendChunk call on a Field object writes data to the field, overwriting any existing data. Subsequent AppendChunk calls add to existing data. If you are appending data to one field and then you set or read the value of another field in the current record, ADO assumes that you are done appending data to the first field. If you call the AppendChunk method on the first field again, ADO interprets the call as a new AppendChunk operation and overwrites the existing data. Accessing fields in other Recordset objects (that are not clones of the first Recordset object) will not disrupt AppendChunk operations.
If there is no current record when you call AppendChunk on a Field object, an error occurs.
Parameter
Each AppendChunk call on a Parameter object appends to existing parameter data. An AppendChunk call that passes a Null value generates an error; you must manually set the Value property of the Parameter object to a zero-length string ("") in order to clear its value.