MDAC 2.5 SDK - OLE DB Programmer's Reference
Appendix C: OLE DB Properties

DBPROP_OTHERINSERT

Property group: Rowset

Property set: DBPROPSET_ROWSET

Column? N

Type: VT_BOOL

Typical R/W: R/W

Description: Others' Inserts Visible

Value	Meaning
VARIANT_TRUE	The rowset can see rows inserted by someone other than a consumer of the rowset. That is, if someone other than a consumer of the rowset inserts a row, any consumer of the rowset will see that row the next time it fetches a set of rows containing it. This includes rows inserted by other parties in the same transaction as well as rows inserted by parties outside the transaction. For more information about visibility of inserted rows, see "Visibility of Other Changes" in Chapter 5, "Updating Data in Rowsets." Note The transaction isolation level does not affect the ability of the rowset to see rows inserted by other parties in the same transaction, such as other rowsets in the same session. However, it does restrict the ability of the rowset to see rows inserted by parties outside the transaction.
VARIANT_FALSE	The rowset cannot see rows inserted by others.

For programmers accustomed to the cursor model in ODBC, the DBPROP_OTHERUPDATEDELETE and DBPROP_OTHERINSERT properties correspond to ODBC cursors as follows.

Static cursor:
- DBPROP_OTHERINSERT = VARIANT_FALSE
- DBPROP_OTHERUPDATEDELETE = VARIANT_FALSE
Keyset-driven cursor:
- DBPROP_OTHERINSERT = VARIANT_FALSE
- DBPROP_OTHERUPDATEDELETE = VARIANT_TRUE
Dynamic cursor:
- DBPROP_OTHERINSERT = VARIANT_TRUE
- DBPROP_OTHERUPDATEDELETE = VARIANT_TRUE

Furthermore, the DBPROP_OWNUPDATEDELETE and DBPROP_OWNINSERT properties correspond to the values returned by the SQL_STATIC_SENSITIVITY information type in SQLGetInfo in ODBC.

For a description of how these properties relate to transaction isolation level, see "Visibility of Other Changes" in Chapter 5, "Updating Data in Rowsets."