TRANSFERFIELDS Function (Record)

Copies all matching fields in one record to another record.

Record.TRANSFERFIELDS(FromRecord [, InitPrimaryKeyFields])

Parameters

  • Record
    Type: Record The record to which you want to copy the contents of the fields in FromRecord.
  • FromRecord
    Type: Record The record from which to copy.
  • InitPrimaryKeyFields
    Type: Boolean Default: true If this parameter is true and the records are in the same table, both the timestamp and the Primary Key fields of the destination record will be changed. If this parameter is true and the records are not in the same table, then the Primary Key fields of the destination record will be changed but the timestamp of the destination record will not be changed. If this parameter is false, then neither the timestamp nor the Primary Key fields of the destination record are changed.

Remarks

TRANSFERFIELDS copies fields based on the Field No. Property of the fields. For each field in Record (the destination), the contents of the field that has the same Field No. in FromRecord (the source) will be copied, if such a field exists.

The fields must have the same data type for the copying to succeed (text and code are convertible, other types are not.) There must be room for the actual length of the contents of the field to be copied in the field to which it is to be copied. If any one of these conditions are not fulfilled, a run-time error will occur.

Example

This example shows how to use the TRANSFERFIELDS function together with a BLOB field. If you are copying a record that contains a BLOB field, then you must calculate the BLOB field before it can be copied with the rest of the record. This example requires that you create the following variables in the C/AL Globals window.

Variable name DataType Subtype

GLAccountRec

Record

G/L Account

FromRecord

Record

G/L Account

…
IF GLAccountRec.Picture.HASVALUE THEN
  GLAccountRec.CALCFIELDS(Picture);
GLAccountRec.TRANSFERFIELDS(FromRecord);
GLAccountRec.INSERT(TRUE);

See Also

Reference

Record Data Type