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.