>>>>I tried tablerevert(.t.) but it does not work. I guess at the time of the error the current alias is "lost" and tablerevert() needs an alias to work with.
>>>
>>>Yes, switch to the right DS and try tablerevert and more importantly - rollback transaction.
>>
>>How do you switch to the right DS? Is there a comment that will show me list of DSs?
>
>When you're in the command window, type set. You'll see all the datasessions which are currently opened.
>
>You can also try
>
>=asessions(laSessions)
>
>for lnI = 1 to alen(laSessions)
> set datasession to (laSession[ln])
>
> if TXNLEVEL( ) > 0
> rollback transaction
> endif
>next
Thank you. I will save this code and try it next time I run into the problem.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham