Report Multiple Changes Property
From ADO and SQL Server
ADO and SQL Server
Report Multiple Changes Property
The Report Multiple Changes property indicates whether an update or delete operation can affect multiple rows.
Applies To
| Command Object | Recordset Object |
Syntax
object.Properties("Report Multiple Changes")
Parts
object
Expression that evaluates to an object in the Applies To list.
Returns
One of the following settings:
| Value | Description |
|---|---|
| True | An update or delete operation can affect multiple rows, and the provider can detect that multiple rows have been updated or deleted. This happens when a provider cannot uniquely identify a row. For example, the provider might use the values of all the columns in the row to identify the row; if these columns do not include a unique key, an update or delete might affect more than one row. |
| False | An update or delete always affects a single row, or the provider cannot detect whether it affects multiple rows. |
Data Type
adBoolean
Modifiable
Read-only
OLE DB Property
DBPROP_REPORTMULTIPLECHANGES