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.