DataTransfer Data type
Version: Available or changed with runtime version 10.0.
A structure building bulk transfer of data between tables.
The following methods are available on instances of the DataTransfer data type.
Method name | Description |
---|---|
AddConstantValue(Any, Integer) | Specifies the given value is to be set in the given field in the destination table. |
AddFieldValue(Integer, Integer) | Specifies a source and destination field, where the values from the source field are to be copied to the destination field. The data types of the fields must match, except CODE to TEXT which is allowed. |
AddJoin(Integer, Integer) | Adds a field pair to be used to create a join condition which determines which rows to transfer, optional for same table transfers. |
AddSourceFilter(Integer, Text [, Any,...]) | Adds a filter for the source table for the data transfer. |
CopyFields() | Copies the fields specified in AddFields with filters from AddSourceFilter, and the join conditions from AddJoins in one bulk operation in SQL. |
CopyRows() | Copies the rows from the source table to the destination table with the fields selected with AddFields and the filters applied with AddSourceFilter, in one bulk operation in SQL. |
SetTables(Integer, Integer) | Sets the source and destination tables for the data transfer. |
UpdateAuditFields([Boolean]) | Sets if audit fields should be updated. If the value is set to false, the audit fields are not updated when calling the CopyFields method. Default value is true. |