Editing Multiple Records

ADO has the ability to perform batch updates. This means that you can edit multiple records and send them to the OLE DB provider in a single operation. To take advantage of batch updates, you must use the keyset or static cursor (see Chapter 13).

Part II

The procedure in Hands-On 14-3 finds all records in the Employees table where Title is "Sales Representative" and changes them to "Sales Rep." The changes are then committed to the database in a single update operation.

0 0

Post a comment