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: