Hi Mark -----

BEGIN TRANS
?TXNLEVEL()=1
BEGIN TRANS
?TXNLEVEL()=2
END TRANS
?TXNLEVEL()=1
END TRANS
?TXNLEVEL()=0

This is how it's supposed to go. Do you get this error even when you *know* you only have one open TRANS?


>>
>>TXNLEVEL() returns the current nesting level and 5 is the max.
>>
>
>Thanks for your answer John but I have even try the sample code
>from the help file and It keeps giving me the same error.
>Is there a enviroment var that I forgot to set??
>
>And Is this the way to set up a nested 5 levels max Beg trans -- End trans
>
>BEG TRANS
>some code 1
>BEG TRANS
>some code 2
>.
>.
>.
>END TRANS 2
>END TRANS 1
>
>or You don't think so
>
>mark oliva