Updated: 2018-05-05
OLE DB Property of Rowset and Command — «modify_trans_type»
Name:
modify_trans_type
Type:
VT_I2
R/W:
R/W
Default:
It derives initialization property modify_trans_type
IBProvider:
2, 3, 5
Determination of the transaction utilized for the operations of the record of changes in database. Allowed values:
| Value | Description |
| 0 | If automatic transaction is used for reading of row set data, then separate short transaction will be used for the record of changes (see 2). If user explicitly started transaction to select some data then namely it will be used for data update (see 1). |
| 1 | Main transaction with data selection is used. |
| 2 | Separate short transaction is used. In this mode you can avoid DEAD blocking but there is no any guarantee for database integrity. |
Focus attention that the automatic transaction is committed when closing the row set. Therefore, after setting the property in 1 and after opening row set in automatic transaction, you will not be able to see any changes in database as long as you will not release row set.
See also
- The rowset property modify_trans_level
- The initialization property modify_trans_type