Use a TADUpdateSQL object to provide SQL statements used to post updates from TADQuery, TADStoredProc or TADTable components. 

The TADUpdateSQL allows to override the SQL update commands automatically generated by the datasets, but not to execute the SQL commands and not to post changes to a DB. The usage of TADUpdateSQL is optional in case of TADQuery and TADTable. Because they are capable to automatically generate the SQL commands to post updates from a dataset to a DB. And the usage is mandatory for TADStoredProc. 

To specify SQL commands at design-time use the TADUpdateSQL 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 update SQL use the Commands property.

TADUpdateSQL = class(TADCustomUpdateObject);

Overriding Posting Updates, TADQuery, TADStoredProc, TADTable, TADCustomUpdateObject, TADAdaptedDataSet.UpdateObject