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