DataTransfer.AddConstantValue(Any, Integer) Method
Version: Available or changed with runtime version 10.0.
Specifies the given value is to be set in the given field in the destination table.
Syntax
DataTransfer.AddConstantValue(Value: Any, DestinationField: Integer)
Parameters
DataTransfer
Type: DataTransfer
An instance of the DataTransfer data type.
Value
Type: Any
The value to set in the destination field.
DestinationField
Type: Integer
The destination table field.
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 to set a constant value for a field when copying data in rows or fields of table to another table. For more information, see Transferring Data Bewteen 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;
See Also
DataTransfer Data Type
Getting Started with AL
Developing Extensions
反馈
https://aka.ms/ContentUserFeedback。
即将发布:在整个 2024 年,我们将逐步淘汰作为内容反馈机制的“GitHub 问题”,并将其取代为新的反馈系统。 有关详细信息,请参阅:提交和查看相关反馈