>Hi,
> Do you meant I need to issue END TRANSACTION and then TABLEREVERT()? But the data will be saved after END TRANSACTION, will tablerevert() able to REVERT them?
>
>Thank you

I'm sorry, John, I misread your code...

What you're doing looks fine to me. Are you sure there is no other place in the form that issues a BEGIN TRANSACTION?