O'Reilly logo

Delphi for .NET Developer’s Guide by Xavier Pacheco

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required