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. .gif "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