FireDAC.Comp.Client.TFDUpdateSQL
| [–] Properties | |
|---|---|
| Type: class | |
| Visibility: public | |
| Source: FireDAC.Comp.Client.pas FireDAC.Comp.Client.hpp
| |
| Unit: FireDAC.Comp.Client | |
| Parent: FireDAC.Comp.Client | |
Delphi
TFDUpdateSQL = class(TFDCustomUpdateObject)
C++
class PASCALIMPLEMENTATION TFDUpdateSQL : public TFDCustomUpdateObject
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