DataTransfer.SetTables(Integer, Integer) Method

Version: Available or changed with runtime version 10.0.

Sets the source and destination tables for the data transfer.

Syntax

 DataTransfer.SetTables(SourceTable: Integer, DestinationTable: Integer)

Parameters

DataTransfer
 Type: DataTransfer
An instance of the DataTransfer data type.

SourceTable
 Type: Integer
The source table for the transfer.

DestinationTable
 Type: Integer
The destination table for the transfer.

Remarks

The DataTransfer object can only be used in upgrade code and it will throw an runtime error if used outside of upgrade codeunits.

Use this method when copying data in rows or fields of table to rows or fields of another table. For more information, see Transferring Data Between Tables.

Example

In this code example, you copy the PK and S3 fields in the Source table for all rows where S2 equals A and add them as new rows in the Destination table. You use AddConstantValue method to give the field D2 the value X in the inserted rows.

local procedure CopyRows()
var
    dt: DataTransfer;
    src: Record Source;
    dest : Record Destination;
begin
    dt.SetTables(Database::Source, Database::Destination);
    dt.AddFieldValue(src.FieldNo("PK"), dest.FieldNo("PK"));
    dt.AddFieldValue(src.FieldNo("S3"), dest.FieldNo("D3"));
    dt.AddConstantValue('X', dest.FieldNo(D2));
    dt.AddSourceFilter(src.FieldNo("S2"), '=%1', 'A');
    dt.CopyRows();
end;

DataTransfer Data Type
Getting Started with AL
Developing Extensions