TADUpdateSQL applies updates on behalf of queries or stored procedures that can't post updates directly.
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.
What do you think about this topic? Send feedback!