I have a question about creating a database transaction using Xano. I have two tables, Basket and Orders. I need to copy records from Basket to Orders according to user_id (and other parameters). I have created the steps to do this and it works.
However, i need to convert these actions into a database transaction in such a way that if the record copying process onto the Orders table fails for whatever reason, the transaction is reverted. How can I accomplish this?
Than you for your help