Updating Data in Rowsets

SQLOLEDB updates Microsoft® SQL Server™ 2000 data when a consumer updates a modifiable rowset containing that data. A modifiable rowset is created when the consumer requests support for either the IRowsetChange or IRowsetUpdate interface.

All SQLOLEDB modifiable rowsets use SQL Server 2000 cursors to support the rowset. The OLE DB rowset property DBPROP_LOCKMODE alters SQL Server 2000 concurrency control behavior in cursors and determines the behavior of rowset row fetching and data integrity error generation in updatable rowsets.

SQLOLEDB supports row synchronization before or after an update.