MDAC 2.5 SDK - OLE DB Programmer's Reference
Chapter 5: Updating Data in Rowsets


 

Visibility of Changes

If a consumer makes a change to a row in a rowset, releases the row handle for that row, refetches the same row from the data store into the rowset, and calls IRowset::GetData on the row, does the consumer see the change it made? If so, the change is said to be visible to the rowset. If other rowsets also make changes to the same row, those changes may or may not be visible to the first rowset.

Whether a change to a row is visible, and to whom, depends on many factors, such as whether the change is pending or transmitted, whether it affects the row's position in the rowset, and whether it was made inside a transaction. It also depends on the values of various rowset properties. The following sections discuss these properties and their effects on visibility of changes.