Bde.DBTables.TBatchMove.Source

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

property Source: TBDEDataSet read FSource write SetSource;

C++

__property TBDEDataSet* Source = {read=FSource, write=SetSource};

Properties

Type Visibility Source Unit Parent
property published
Bde.DBTables.pas
Bde.DBTables.hpp
Bde.DBTables TBatchMove

Description

Specifies the dataset that is the source of the batch operation.

Use Source to indicate the dataset that contains the records that will be added to, subtracted from, or copied to the Destination. If Source is a TQuery component, the query is executed before the move is executed. If a filter is currently in effect on Source, the filter conditions are respected when the batch move executes. The Mode property indicates how the Source records are applied to the Destination:



Mode Effect on Destination

batAppend

Records are added to the destination table.

batUpdate

Records in the destination table with key fields matching the corresponding fields in the source are changed to match the source records.

batAppendUpdate

Records in the destination table with key fields matching the corresponding fields in the source are changed to match the source. Source records that do not match key fields are added to the destination table.

batDelete

Records in the destination table that match the records in the source are deleted.

batCopy

Destination table is created to match the records in the source.



See Also