Click or drag to resize

TxnLevel Function

X#
-- todo --
Returns a numeric value indicating the current transaction level.

Namespace:  XSharp.VFP
Assembly:  XSharp.VFP (in XSharp.VFP.dll) Version: 2.19
Syntax
 FUNCTION TxnLevel() AS LONG
Request Example View Source

Return Value

Type: Long
TXNLEVEL( )Return Value Numeric
Remarks
Use BEGIN TRANSACTION to create a transaction. Transactions are nested by issuing BEGIN TRANSACTION when another transaction is in progress. Transactions can be nested in this manner to five levels. Use TXNLEVEL( ) to determine the current transaction level.
TXNLEVEL( ) returns a value from 0 to 5. TXNLEVEL( ) returns 0 if a transaction is not in progress.
Examples
X#
 1Close Databases
 2Open Database (HOME(2) + 'Data\testdata')
 3Use Customer     // Open customer table
 4Clear
 5BEGIN TRANSACTION
 6tLevel = ALLTRIM(STR(TXNLEVEL()))
 7=MessageBox("Current Transaction: " + tLevel, 0, "Transaction Level")
 8BEGIN TRANSACTION
 9tLevel = ALLTRIM(STR(TXNLEVEL()))
10=MessageBox("Current Transaction: " + tLevel, 0, ;
11"Transaction Level")
12END TRANSACTION
13END TRANSACTION
See Also