Visibility of Other Changes

OLE DB Programmer's Reference

If a consumer completely releases and then refetches a row handle on a row that has been changed by another rowset or consumer, whether the consumer can see these changes depends on the DBPROP_OTHERUPDATEDELETE and DBPROP_OTHERINSERT properties.

The visibility of changes made by other rowsets in the same transaction depends only on these properties. It does not depend on the transaction isolation level because the changes are in the same transaction.

The visibility of changes made by applications outside the current transaction depends on the values of these properties as well as on the transaction isolation level, as shown in the following table.

Property value	Read uncommitted	Read committed	Repeatable read	Serializable
DBPROP_OTHERUPDATEDELETE: VARIANT_TRUE VARIANT_FALSE	Yes No	Yes No	No No	No No
DBPROP_OTHERINSERT: VARIANT_TRUE VARIANT_FALSE	Yes No	Yes No	Yes No	No No

1998-2001 Microsoft Corporation. All rights reserved.