No, you are correct. What you are wrapping in the transaction is the tableupdate, in effect.

You only want to tablerevert if the transaction was unsuccessful, which you only know after you've tried it, of course. And once you know it was unsuccessful, the first order of business to rollback the updates that did take place, which ends the transaction. Then you are free to use the buffered data or not. At least, that how I think about the "why" of what order these things come in. :-)

>Nancy,
>Thanks once again!!
>What confused us here was that going the other way, we issue the
>TABLEUPDATE() and then the END TRANSACTION or should that also be in reverse order??
>
>Sandy