Visibility of Changes

OLE DB Programmer's Reference

When a consumer updates or deletes a row, changes might or might not be visible when the consumer releases the row handle and refetches the row. The same uncertainty exists about updates to dependent properties. The solution depends on the rowset property DBPROP_OWNUPDATEDELETE. If the value of this property is VARIANT_TRUE, the changes are visible on refetching. If the value is VARIANT_FALSE, the changes are not visible unless the command is reexecuted.

Note   Explicit consumer updates are known to the consumer. Therefore, there is no need to refetch the updated rows. However, explicit updates might result in implicit updates of the dependent properties. The consumer needs to refetch or reexecute the command to see these changes.

Visibility of Changes in the Dataset

Because a consumer can be actively navigating through the dataset when making changes through the range rowset, it might not be known when changes are visible in that dataset. It is the provider's responsibility to implement a solution in this case.

1998-2001 Microsoft Corporation. All rights reserved.