FireDAC.Comp.Client.TFDUpdateSQL

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

Delphi

TFDUpdateSQL = class(TFDCustomUpdateObject)

C++

class PASCALIMPLEMENTATION TFDUpdateSQL : public TFDCustomUpdateObject

Properties

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

Description

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

• Overriding Posting Updates
• FireDAC.Comp.Client.TFDQuery
• FireDAC.Comp.Client.TFDStoredProc
• FireDAC.Comp.Client.TFDTable
• FireDAC.Comp.Client.TFDCustomUpdateObject
• FireDAC.Comp.Client.TFDAdaptedDataSet.UpdateObject

Samples

• FireDAC TFDQuery OnUpdateRecord sample