We would like to use Smart Service to delete records from the DSE (Data Store Entity) and create records according to the input received from the screen.In this case, will the Delete and Write transactions be separated?For example, if Write after Delete fails for some reason, I would like the Delete transaction to rollback.
Please let me know if there is a way to execute Delete and Write in the same transaction on Smart Service.
Discussion posts and replies are publicly visible
I my experience, it is a better approach to not make the database manage a transaction, but to look at the Appian process to be that instance.
Thanks for the answer. I understand what you mean but in order to fulfill the request from the client we need to create many different tables to manage the data. I'm a little nervous when doing data write or delete in tables without transaction manager.