Share via


Visibility of Other Changes

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

This topic is a part of: