From RAD Studio API Documentation
Jump to: navigation, search



TFDUpdateSQL = class(TFDCustomUpdateObject)


class PASCALIMPLEMENTATION TFDUpdateSQL : public TFDCustomUpdateObject


Type Visibility Source Unit Parent
class public
FireDAC.Comp.Client FireDAC.Comp.Client


This class applies updates on behalf of queries or stored procedures that cannot post updates directly.

Use a TFDUpdateSQL object to provide SQL statements for posting updates from TFDQuery, TFDStoredProc, or TFDTable components. 

TFDUpdateSQL allows to automatically override the SQL update commands generated by the datasets, but it does not allow to execute the SQL commands and to post changes to a DB. The usage of TFDUpdateSQL is optional for TFDQuery and TFDTable because these components are capable of automatically generating SQL commands and post updates from a dataset to a DB. However, the usage of TFDUpdateSQL is mandatory for TFDStoredProc

To specify SQL commands at design time, use the TFDUpdateSQL design-time editor, by double-clicking a component. To specify SQL commands at run time, use the ModifySQL, InsertSQL, DeleteSQL, and other properties. To specify additional parameter or macro values for specific SQL updates, use the Commands property.

See Also