Question
1
Replies
340
Views
Posted: July 11, 2017
Last activity: September 6, 2017
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.
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.