Objects Transacted Property
From ADO and SQL Server
ADO and SQL Server
Objects Transacted Property
The Objects Transacted property specifies whether an object created on the referenced columns can be committed in a transaction.
Applies To
| Command Object | Recordset Object |
Syntax
object.Properties("Objects Transacted") [= value]
Parts
object
Expression that evaluates to an object in the Applies To list.
value
Boolean that specifies whether the object can be committed in a transaction, as specified in Settings.
Settings
| Value | Description |
|---|---|
| True | Any object created on the referenced column can be transacted. Data made visible to the database through the object can be committed with CommitTrans or aborted with Rollback. |
| False | Any object created on the referenced column cannot be transacted. All changes to the object are permanent once they are made visible to the database. |
Data Type
adBoolean
Modifiable
Read/write
OLE DB Property
DBPROP_TRANSACTEDOBJECT
Remarks
If the Objects Transacted property is set on a column that does not contain an object, it is ignored.