Transaction DDL Property
The Transaction DDL property indicates the relationship of transactions to table and index modification data definition language (DDL) statements.
Applies To
| Connection Object |
Syntax
object.Properties("Transaction DDL")
Parts
object
Expression that evaluates to an object in the Applies To list.
Returns
One of the following settings:
| Constant | Description |
|---|---|
| DBPROPVAL_TC_NONE | Transactions are not supported. |
| DBPROPVAL_TC_DML | Transactions can contain only data manipulation language (DML) statements. Attempting to modify tables or indexes within a transaction causes an error. |
| DBPROPVAL_TC_DDL_COMMIT | Transactions can contain only DML statements. Modifying tables or indexes within a transaction causes the transaction to be committed. The provider's commit mode remains unchanged in accordance with the value of the Preserve on Commit property. If the provider is in auto-commit mode, it remains in auto-commit mode. If the provider is in manual-commit mode, it remains in manual-commit mode. |
| DBPROPVAL_TC_DDL_IGNORE | Transactions can contain only DML statements. Attempts to modify tables or indexes within a transaction are ignored. DDL operations are not transacted even if a session is participating in a transaction. If the DDL method succeeds, the operation is complete and unaffected by subsequent calls to abort or commit the transaction. |
| DBPROPVAL_TC_DDL_LOCK | Transactions can contain both DML and table or index modifications, but modifying a table or index within a transaction causes the table or index to be locked until the transaction completes. |
| DBPROPVAL_TC_ALL | Transactions can contain DML statements, as well as table or index modifications, in any order. |
Data Type
adInteger
Modifiable
Read-only
OLE DB Property
DBPROP_SUPPORTEDTXNDDL