Maximum Pending Rows Property

ADO and SQL Server

ADO and SQL Server

Maximum Pending Rows Property

The Maximum Pending Rows property specifies the maximum number of rows that can have pending changes at the same time.

Applies To
Command Object Recordset Object
Syntax

object.Properties("Maximum Pending Rows") [= value]

Parts

object

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

value

Integer that specifies the maximum number of rows that can have pending changes.

Data Type

adInteger

Modifiable

Read/write

OLE DB Property

DBPROP_MAXPENDINGROWS

Remarks

This limit on the maximum number of pending rows does not reflect resource limitations such as Random Access Memory (RAM), but does apply if the recordset implementation uses some strategy that results in a limit.

If there is no limit, the value of the Maximum Pending Rows property is set to zero. The provider is free to support a greater number of pending rows than the maximum specified by the application. In this case, the provider will return the actual maximum number of pending rows instead of the value specified by the application.