>IF that's the case, in the event there is an error in tableupdate,
>will rollback be enough or do we have to give a tablerevert to every
>table as well??

TABLEREVERT(). Of course, after you ROLLBACK, you can try to fix the problem, and try the whole BEGIN TRANSACTION...TABLEUPDATE() sequence again, rather than reverting your changes....