Updating Data in Rowsets


System_CAPS_ICON_warning.jpg Warning

SQL Server Native Client (SNAC) is not supported beyond SQL Server 2012. Avoid using SNAC in new development work, and plan to modify applications that currently use it. The Microsoft ODBC Driver for SQL Server provides native connectivity from Windows to Microsoft SQL Server and Microsoft Azure SQL Database.

The SQL Server Native Client OLE DB provider updates SQL Server data when a consumer updates a modifiable rowset that contains that data. A modifiable rowset is created when the consumer requests support for either the IRowsetChange or IRowsetUpdate interface.

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

The SQL Server Native Client OLE DB provider supports row synchronization before or after an update.

System_CAPS_ICON_note.jpg Note

IRowChange::SetColumns is available to set the values of one or more named columns of a row object.


Community Additions