AppendChunk Method (DAO)

Microsoft DAO 3.60

AppendChunk Method

           

Appends data from a string expression to a Memo or Long Binary Field object in a Recordset.

Syntax

recordset ! field.AppendChunk source

The AppendChunk method syntax has these parts.

Part Description
recordset An object variable that represents the Recordset object containing the Fields collection.
field An object variable that represents the name of a Field object whose Type property is set to dbMemo (Memo), dbLongBinary (Long Binary), or the equivalent.
source A Variant (String subtype) expression or variable containing the data you want to append to the Field object specified by field.

Remarks

You can use the AppendChunk and GetChunk methods to access subsets of data in a Memo or Long Binary field.

You can also use these methods to conserve string space when you work with Memo and Long Binary fields. Certain operations (copying, for example) involve temporary strings. If string space is limited, you may need to work with chunks of a field instead of the entire field.

If there is no current record when you use AppendChunk, an error occurs.

Notes

  • The initial AppendChunk operation (after an Edit or AddNew call) will simply place the data in the field, overwriting any existing data. Subsequent AppendChunk calls within the same Edit or AddNew session will then add to the existing data.

  • In an ODBCDirect workspace, unless you first edit another field in the current record, using AppendChunk will fail (though no error occurs) while you are in Edit mode.

  • In an ODBCDirect workspace, after you use AppendChunk on a field, you cannot read or write that field in an assignment statement until you move off the current record and then return to it. You can do this by using the MoveNext and MovePrevious methods.