ADO AppendChunk method
Definition and usage
AppendChunk is used to append data to large text or binary data Field or to the Parameter object.
Tip: Use the AppendChunk method of the Field or Parameter object to fill long binary or character data. In cases where system memory is limited, the AppendChunk method can be used to operate on a partial rather than the entire Long value.
| Object | Description of the AppendChunk method |
|---|---|
| Parameter |
If the adFldLong bit is set to True in the Attributes property of the Parameter object, the AppendChunk method can be used for this parameter. The first AppendChunk call on the Parameter object writes data to the parameter, overwriting any existing data. Subsequent AppendChunk calls on the Parameter object add data to the existing parameter data. An AppendChunk call with a Null value abandons all parameter data. |
| Field |
If the adFldLong bit is set to True in the Attributes property of the Field object, the AppendChunk method can be used for this field. The first AppendChunk call on the Field object writes data to the field, overwriting any existing data. Subsequent AppendChunk calls add data to the existing data. If you want to append data to a field and then set or read the value of other fields in the current record, ADO considers that the data has been appended to the first field. If the AppendChunk method is called again on the first field, ADO interprets this call as a new AppendChunk operation and overwrites the existing data. Accessing fields in other Recordset objects (not copies of the first Recordset object) will not interrupt the AppendChunk operation. An error will occur when calling AppendChunk on the Field object if there is no current record. Note: The AppendChunk method does not work on the Field object of the Record object. It does not perform any operation and will cause a runtime error. |
Syntax
objectname.AppendChunk data
| Parameter | Description |
|---|---|
| data | Variant, containing data to be appended to the object. |
