Wellll......

I am totally dumbfounded Mark. Have you tried to reduce to a single transaction and see if *that* works?


>Hey Hello John:
>to answer your question yes I still get the error
>this is the testing code I am using
>
>@@@@@@@--------@@@@@@@@@@@@@
>CLOSE DATABASES
>OPEN DATABASE first
>USE onetab1 && Open customer table
>CLEAR
>BEGIN TRANSACTION
> ? 'Transaction level '
> ?? TXNLEVEL( )
> BEGIN TRANSACTION
> ? 'Transaction level '
> ?? TXNLEVEL( )
> END TRANSACTION
>END TRANSACTION
>
>
>mark oliva
>
>
>>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?