06-27-2011 10:47 AM
Solved! Go to Solution.
06-27-2011 05:45 PM
06-28-2011 07:23 AM
The benefit of a transaction management system, for example, I have an script which executes four queries for each record proccesed. What I need is to rollback the executed query N°1 and N°2, if the execution of query N°3 presents an error.
I never heard about this functionality with SM, but maybe someone could suprise me.
06-30-2011 01:21 AM
I understand the potential benefits of rolling back an INSERT/UPDATE/DELETE transaction. What would be gained by rolling back a SELECT statement?
From a SM perspective, the custom solution should be designed so the query is properly formed. The RAD work-flow in SM will take different exits based on the result of a query. The "select" panel has exits for 0 records matched, 1 record matched, and more than 1 record matched. If a query generates an error, the work-flow will take the error exit.