Show: Delphi C++
Display Preferences

FireDAC.Comp.Client.TFDUpdateSQL

From RAD Studio API Documentation
Jump to: navigation, search

FireDAC.Comp.Client.TFDCustomUpdateObjectFireDAC.Stan.Intf.TFDComponentSystem.Classes.TComponentSystem.Classes.TPersistentSystem.TObjectTFDUpdateSQL

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

Samples

Personal tools
In Other Languages
Previous Versions
Assistance