ADO and SQL Server
Own Inserts Visible Property
The Own Inserts Visible property specifies whether row inserts by the application accessing a recordset are visible without statement reexecution.
Applies To
| Command Object | Recordset Object |
Syntax
object.Properties("Own Inserts Visible") [= value]
Parts
object
Expression that evaluates to an object in the Applies To list.
value
Boolean that specifies whether inserts by the application are visible, as described in Settings.
Settings
| Value | Description |
|---|---|
| True | Inserts to the recordset are visible. If an application accessing a recordset inserts a row, that row is visible to any application accessing the recordset the next time the application fetches a set of rows containing that row. This ability is independent of the transaction isolation level because all applications accessing the recordset share the same transaction. |
| False | Changes to the recordset (updates and deletes) made by applications accessing the recordset are not visible unless the command is reexecuted. |
Data Type
adBoolean
Modifiable
Read/write
OLE DB Property
DBPROP_OWNINSERT
See Also
Others' Changes Visible Property