Bde.DBTables.TBatchMove.Source
| [–] Properties | |
|---|---|
| Type: property | |
| Visibility: published | |
| Source: Bde.DBTables.pas Bde.DBTables.hpp
| |
| Unit: Bde.DBTables | |
| Parent: TBatchMove | |
Delphi
property Source: TBDEDataSet read FSource write SetSource;
C++
__property TBDEDataSet* Source = {read=FSource, write=SetSource};
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. |