DBPROP_OTHERINSERT

OLE DB Programmer's Reference

Property group: Rowset

Property set: DBPROPSET_ROWSET

Column? N

Type: VT_BOOL

Typical R/W: R/W

Description: Others' Inserts Visible

For more information about visibility of inserted rows and a description of how these properties relate to transaction isolation level and inserts, see "Visibility of Other Changes" in Chapter 5: Updating Data in Rowsets.

Value	Meaning
VARIANT_TRUE	Rows inserted by a consumer or process other than a consumer of the rowset are visible. That is, any consumer of the rowset will see those rows the next time it fetches a set of rows containing the changed rows, whatever process changed that row. This includes rows inserted in the same transaction as well as rows inserted outside the transaction by others. Note   The transaction isolation level does not affect the visibility of rows inserted by others in the same transaction, such as other rowsets in the same session. However, it does restrict the visibility of rows inserted by others outside the transaction.
VARIANT_FALSE	Inserts to the rowset made by other consumers of the rowset are not visible unless the command is reexecuted.

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

1998-2001 Microsoft Corporation. All rights reserved.