TurboDB VCL Component Library

Executing a Batch Move

Previous  Top  Next

The BatchMove component is a powerful and flexible way to transfer records from and to different data sources. You can use different flat files and all TDataSet descendants as data sources.

To execute a batch move:

1)Set the TdbDataSet property to the TTdbTable component where you want to import from or to export to.
2)Set the FileName or the DataSet property to the file or the data set of the other data source.
3)If the other data source is a file, set the  FileType property according to the file format of the other data source.
4)If the other data source is a text file (i.e. FileType has been set to tffSDF), set QuoteSeparator and ColumnNames to the appropriate values.
5)If the other data source is a text file or a dBase file, set CharSet to the appropriate value.
6)Set the Direction property to bmdImport, if you want to transfer records from the other data source into the TurboDB table. Set it to bmdExport, if you want to create a file with records of your TurboDB table.
7)Set the Mode property to the kind of batch move you want to perform.
8)Add the column mappings between the source and target to the Mappings property.
9)Set the Filter property to restrict the import or export to a subset of the source data set.
10) Register an event handler for the OnProgress event to show the progress of the batch move process and to offer the user a way of interrupting the operation.
11) Call the Execute method to start the batch move.