Microsoft OLE DB 2.0 Programmers Reference and Data Access SDK (Microsoft Professional Editions)
| 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.