Question
1
Replies
340
Views
Posted: July 11, 2017
Last activity: September 6, 2017
Closed
Solved
To revert RDB-Save Commit from PRPC
Hi ,
Is there any way to have Control of RDB-save Commit from PRPC.If there is any such settings please let me know.Does AutoDbSchemaChanges Dss will be helpful for this.
Please confirm.
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Hi,
PRPC RDB operations are implemented as a single-statement transaction. RDB- methods immediately commit their changes to the database. However there is an alternative to implement this.
You can write a stored procedure to complete the insert/update operation. You can do the commit or rollback inside your stored procedure if any one of your operations fails. Invoke your stored procedure from a Connect-SQL.