Database Transaction rollback

Database Transaction rollback

  

Hi all,

I have a Save action that add new record to 3 database table.If adding record to any table fail , all the record should be rollback.

Does anyone has idea how to do this?Help!!


Solution

Hi Johnson,

The platform handles that for you. All database operations executed within the same request are run inside the same transaction. So if one of them throws an exception that is not handled by you, a rollback is automatically executed. If you do handle the exception with an "Exception Handler" element, you can choose whether you want to roll back the transaction. More info here.

Solution

Thanks Aurelio