rs("data").GetChunk GetChunk Method - ADO Returns all or a portion of the contents of a large text or binary data Field object. Applies To Field Syntax variable = field.GetChunk( Size ) Return Values Returns a Variant. Parameters Size A Long expression equal to the number of bytes or characters you want to retrieve. Res 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 data a GetChunk call returns is assigned to variable. If Size is greater than the remaining data, the GetChunk method returns only the remaining data without padding variable 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 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. If the adFldLong bit in the Attributes property of a Field object is set to true, 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, error 3021 (no current record) occurs.
dim aa as object set aa =rs("字段").getchunk(字段大小) 是这样的吗? 字段大小怎么确定? 在数据库中看该字段是OLE对象。怎么看大小?
我试验了,但是读出来的全是乱码。你知道这是什么原因吗?还有这个字段的类别是ole对象。 const VarSize=100 dim varLongSize as long varLongSize=rs("字段").actualsize do while LngSize<varLongSize varChunk=rs("字段").getchunk(varsize) varLogo=varlogo & varChunk varLogo=varLogo + varSize loop
GetChunk Method - ADO
Returns all or a portion of the contents of a large text or binary data Field object. Applies To Field Syntax variable = field.GetChunk( Size ) Return Values Returns a Variant. Parameters Size A Long expression equal to the number of bytes or characters you want to retrieve. Res 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 data a GetChunk call returns is assigned to variable. If Size is greater than the remaining data, the GetChunk method returns only the remaining data without padding variable 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 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. If the adFldLong bit in the Attributes property of a Field object is set to true, 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, error 3021 (no current record) occurs.
set aa =rs("字段").getchunk(字段大小)
是这样的吗?
字段大小怎么确定? 在数据库中看该字段是OLE对象。怎么看大小?
const VarSize=100
dim varLongSize as long
varLongSize=rs("字段").actualsize
do while LngSize<varLongSize
varChunk=rs("字段").getchunk(varsize)
varLogo=varlogo & varChunk
varLogo=varLogo + varSize
loop
我的这种情况怎么搞??