ADO and SQL Server
Notification Granularity Property
The Notification Granularity property specifies how to process modifications on multiple rows.
Applies To
| Command Object | Recordset Object |
Syntax
object.Properties("Notification Granularity") [= value]
Parts
object
Expression that evaluates to an object in the Applies To list.
value
Integer specifying how to process modifications, as defined in Settings.
Settings
| Constant | Description |
|---|---|
| DBPROPVAL_NT_SINGLEROW | For methods that operate on multiple rows, the provider processes modifications separately for each phase for each row. A cancellation affects a single row; it does not affect the other rows, and notifications are still sent for these rows. |
| DBPROPVAL_NT_MULTIPLEROWS | For methods that operate on multiple rows and then for each phase, the provider processes modifications once for all rows that succeed and once for all rows that fail. This separation can occur at each phase where a change can fail. For example, if the process deletes some rows and fails to delete others during the preliminary work phase, it processes modifications twice: once with DBEVENTPHASE_SYNCHAFTER and the array of handles of rows that it deleted, and once with DBEVENTPHASE_FAILEDTODO and the array of handles of rows it failed to delete. |
Data Type
adInteger
Modifiable
Read/write
OLE DB Property
DBPROP_NOTIFICATIONGRANULARITY
Remarks
The Notification Granularity property does not affect how providers return notifications about events that affect columns or the entire recordset.