DBPROP_OTHERINSERT

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.

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 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

Show: