Delphi for .NET Developer’s Guide

Updating the Data Source Using Custom Updating Logic

Using custom updating logic simply means that you provide your own INSERT, UPDATE, or DELETE SQL statements as opposed to letting SqlCommandBuilder do this for you. By using custom logic, you can write SQL statements to address scenarios in which SqlCommandBuilder is limited. For instance, you can write logic that updates the data source through a stored procedure. You can also write logic that updates the data source in which the original query was a joined table. In this scenario, you want to update only a subset of the columns. Using SqlCommandBuilder, you have no way of specifying this. Finally, using custom logic, you can handle concurrency in a more optimized fashion than what SqlCommandBuilder ...