IBDAC

TIBCLoader Class

This component serves for loading external data into the database table.

For a list of all members of this type, see TIBCLoader members.

Unit

IBCLoader

Syntax

TIBCLoader = class(TDALoader);

Remarks

The TIBCLoader component allows to load external data into the database table.

TIBCLoader serves for fast loading data to the database. To specify the name of the loading table set the TIBCLoader.TableName property. Use the TIBCLoader.Columns property to access individual columns. Write the TIBCLoader.OnGetColumnData or TIBCLoader.OnPutData event handlers to read external data and pass it to the database. Call the Load method to start loading data.

TIBCLoader loads data by executing INSERT statements. For Firebird 2.0 and higher several INSERT statements are combined in one EXECUTE BLOCK statement to speed up loading (the number of records that are sent to the server at once is controlled by the TIBCLoaderOptions.RowsPerBatch property).

The TIBCLoaderOptions.InsertMode property controls whether the INSERT INTO or UPDATE OR INSERT INTO statement will be used for loading data. Using of UPDATE OR INSERT INTO statements is available in Firebird 2.1 and higher.

Inheritance Hierarchy

TDALoader
   TIBCLoader

© 1997-2020 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback