FireDAC.Comp.BatchMove.DataSet.TFDBatchMoveDataSetWriter

• Up to Parent: FireDAC.Comp.BatchMove.DataSet
• Methods
• Properties
• Events
• Fields

[–] Properties Type: class Visibility: public Source:

FireDAC.Comp.BatchMove.DataSet.pas

FireDAC.Comp.BatchMove.DataSet.hpp

Unit: FireDAC.Comp.BatchMove.DataSet Parent: FireDAC.Comp.BatchMove.DataSet

Delphi

TFDBatchMoveDataSetWriter = class(TFDBatchMoveDataSetDriver, IFDBatchMoveWriter)

C++

class PASCALIMPLEMENTATION TFDBatchMoveDataSetWriter : public TFDBatchMoveDataSetDriver

Description

TFDBatchMoveDataSetWriter is used to define a destination dataset.

Use TFDBatchMoveDataSetWriter to define the destination dataset where to save the data using TFDBatchMove.

Set the DataSet property of TFDBatchMoveDataSetWriter to select the dataset. Choose the TFDBatchMoveDataSetWriter as the Writer property of the TFDBatchMove.

Set the Optimise property to False to allow the dataset content to be visualized using a TDBGrid component. The Optimise property is set to True by default to setup the dataset for optimal writing speed.

Note: Depending on a DBMS, some adjustments may be required:

• Sybase ASE ODBC connection - when the "The CREATE TABLE command is not allowed within a multi-statement transaction in the 'tempdb' database", an exception is raised when TFDBatchMove.Execute is called. If this is the case, use one of the following workarounds:
  • See links below, and configure tempdb to allow DDL's in transaction:
    • http://knowledgebase.progress.com/articles/Article/000043015
    • http://docs.oracle.com/cd/E13189_01/kodo/docs40/full/html/sql_errors.html
  • Set TFDBatchMove.CommitCount to 0 to avoid explicit transactions and use auto-commit mode.

See Also

• FireDAC.TFDBatchMove Sample
• FireDAC.Comp.BatchMove.TFDBatchMove
• FireDAC.Comp.BatchMove.TFDBatchMove.CommitCount
• FireDAC.Comp.BatchMove.Text.TFDBatchMoveTextReader
• FireDAC.Comp.BatchMove.Text.TFDBatchMoveTextWriter
• FireDAC.Comp.BatchMove.DataSet.TFDBatchMoveDataSetReader
• FireDAC.Comp.BatchMove.SQL.TFDBatchMoveSQLReader
• FireDAC.Comp.BatchMove.SQL.TFDBatchMoveSQLWriter