MDAC 2.5 SDK - OLE DB Programmer's Reference
Appendix C: OLE DB Properties

DBPROP_SUPPORTEDTXNDDL

Property group: Data Source Information

Property set: DBPROPSET_DATASOURCEINFO

Type: VT_I4

Typical R/W: R

Description: Transaction DDL

Indicates the relationship of transactions to table and index modification Data Definition Language (DDL) statements. One of the following:

• 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.
  
  
• DBPROPVAL_TC_DDL_IGNORE—Transactions can contain only DML statements. Attempts to modify tables or indexes within a transaction are ignored.
  
  
• 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.