Change Inserted Rows Property

ADO and SQL Server

ADO and SQL Server

Change Inserted Rows Property

The Change Inserted Rows property specifies whether an application can call the Delete or Update methods on a newly inserted row.

Applies To
Command Object Recordset Object
Syntax

object.Properties("Change Inserted Rows") [= value]

Parts

object

Expression that evaluates to an object in the Applies To list.

value

Boolean that indicates whether an application can call the Delete or Update methods as specified in Settings.

Settings
Value Description
True The consumer can call the Delete or Update methods on newly inserted rows.
False If the consumer calls the Delete or Update method for newly inserted rows, Delete returns a status of DBROWSTATUS_E_NEWLYINSERTED for the row and Update returns DB_E_NEWLYINSERTED.

Data Type

adBoolean

Modifiable

Read/write

OLE DB Property

DBPROP_CHANGEINSERTEDROWS

Remarks

A newly inserted row is defined to be a row for which the insertion has been transmitted to the data source, as opposed to a pending insert row.