Visibility of Changes

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

Note   Explicit updates by the consumer are known to it. Therefore, there is no need to refetch the updated rows. However, explicit updates may result in implicit updates of the dependent properties. The consumer needs to refetch or re-execute 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 may not be known when changes are visible in a dataset. The current solution to this is provider-specific.