ADO and SQL Server
Others' Inserts Visible Property
The Others' Inserts Visible property specifies whether row inserts by a process other than the application accessing a recordset are visible without statement reexecution.
Applies To
| Command Object | Recordset Object |
Syntax
object.Properties("Others' Inserts Visible") [= value]
Parts
object
Expression that evaluates to an object in the Applies To list.
value
Boolean that specifies whether inserts by another process are visible, as described in Settings.
Settings
| Value | Description |
|---|---|
| True | Rows inserted by an application or process other than the application accessing the recordset are visible. Therefore, any application accessing the recordset will see those rows the next time it fetches a set of rows containing the inserted rows. This includes rows inserted in the same transaction as well as rows inserted outside the transaction by others.
The transaction isolation level does not affect the visibility of rows inserted by others in the same transaction, such as other recordsets in the same session. However, it does restrict the visibility of rows inserted by others outside the transaction. |
| False | Inserts to the recordset made by other applications accessing the recordset are not visible unless the command is reexecuted. |
Data Type
adBoolean
Modifiable
Read/write
OLE DB Property
DBPROP_OTHERINSERT