Returns all or a portion of the contents of a large text or binary data Field object.
Syntax
Set variable = field.GetChunk(Length)
The GetChunk method syntax has these parts.
|
Part |
Description |
|
variable |
A String or Variant variable that receives the data. |
|
field |
An object variable representing a Field object in the Fields collection of an open Recordset object. |
|
Length |
A Long expression equal to the number of bytes or characters you want to retrieve. |
Remarks
Use the GetChunk method on a Field object to retrieve part or all of its long binary or character data. In situations where system memory is limited, you can use the GetChunk method to manipulate long values in portions rather than in their entirety.
The bytes a GetChunk call returns are assigned to variable. If Length is greater than the number of bytes of remaining data, the GetChunk method returns only the remaining bytes without padding the data with empty spaces. If the field is empty, the GetChunk method returns Null.
Each subsequent GetChunk call retrieves data starting from where the previous GetChunk call left off. However, if you are retrieving data from one field and then you set or read the value of another field in the current record, ADO assumes that you are done retrieving data from the first field. If you call the GetChunk method on the first field again, ADO interprets the call as a new GetChunk operation and starts reading from the beginning of the data. Accessing fields in other Recordset objects (that are not clones of the first Recordset object) will not disrupt GetChunk operations.
The presence of the adFldLong constant in the Attributes property of a Field object indicates that you can use the GetChunk method for that field.
If there is no current record when you use the GetChunk method on a Field object, an error occurs.