|
|
|
|
|
|
|
PROPERTY: |
|
|
|
|
transLevel |
|
|
|
|
|
|
|
|
|
DESCRIPTION: |
|
|
|
|
Indicates the current level of transaction. |
||
|
|
|
|
|
|
|
PROPERTY OF: |
|
|
|
|
|
||
|
|
|
||
|
|
DEFAULT VALUE: |
|
|
|
|
0 |
|
|
|
|
|
|
|
|
|
DESCRIPTION: |
|
|
|
|
This property returns the level of nesting transaction. |
||
|
|
|
|
|
|
|
Determine whether a transaction is currently active for the ADODatabase component. |
||
|
|
If is in a transaction, transLevel property contains a number of nesting level of transaction, otherwise contains zero. |
||
|
|
|
|
|
|
|
Use the transLevel property to prevent calling beginTrans() method when a transaction has already been initiated for the ADODatabase component. |
||
|
|
The calling beginTrans() method will inrease the nesting level of transaction, decreased by calling commit() or rollback() method. |
||
|
|
|
|
|
|
|
For providers that support nested transactions calling the beginTrans() method within an open transaction starts a new, nested transaction. |
||
|
|
The transLevel property contains value of "1" indicates you have opened a top-level transaction (that is, the transaction is not nested within another transaction), |
||
|
|
"2" indicates that you have opened a second-level transaction (a transaction nested within a top-level transaction), and so forth. |
||
|
|
Calling commit() or rollback() method affects only the most recently opened transaction; |
||
|
|
you must close or roll back the current transaction before you can resolve any higher-level transactions. |
||
|
|
|
|
|
|
|
Not all database providers support the nested transactions. |
||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
|
|
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
|
|