Correct. First you ROLLBACK the changes to the tables, then you TABLEREVERT() the buffer. Hmmm, maybe the function *should* have been called CURSORREVERT(), instead of TABLEREVERT...

Side note: if the updates are successful then you have to explicitly END TRANSACTION. But if you ROLLBACK, well, that implicity ends the transaction. (That wasn't obvious to me at first, anyway.)

>Nancy,
>your answer helped clean up some issues,
>
>Now one more issue, I noticed that you RollBack and then
>TableRevert(). Is there an issue here??