ADO and SQL Server

Delay Storage Object Updates Property

The Delay Storage Object Updates property specifies whether changes to storage objects are immediately transmitted to the data source when delayed update mode is in effect.

Applies To
Command Object Recordset Object

Syntax

object.Properties("Delay Storage Object Updates") [= value]

Parts

object

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

value

Boolean that indicates whether changes to storage objects are immediately transmitted, as specified in Settings.

Settings
Value Description
True Changes to the object are not transmitted to the data source until the Update method is called.
CancelBatch undoes any pending changes.
False Changes to the object are immediately transmitted to the data source object. The Update method has no effect on the object.
CancelBatch does not undo changes made to the object since the row was last fetched or updated.

Data Type

adBoolean

Modifiable

Read/write

OLE DB Property

DBPROP_DELAYSTORAGEOBJECTS

Remarks

The Delay Storage Object Updates property has no effect on storage objects in immediate update mode.