Community
Showing results for 
Search instead for 
Do you mean 
Reply

Is there a roll back mechanism in ACT!

Accepted Solution Solved
Copper Contributor
Posts: 16
Country: New Zealand
Accepted Solution

Is there a roll back mechanism in ACT!

After I assign the new values to my company records, I call Update() to commit the change, is there anyway we can rollback this update?

 

Is Cancel() the method to go?

 

 

Thanks 


Accepted Solutions
Solution
Accepted by topic author zhili
‎09-25-2015 03:20 AM
Copper Contributor
Posts: 16
Country: New Zealand

Re: Is there a roll back mechanism in ACT!

Just found out myself that putting any ACT! database operations within a .NET transaction scope will do the job. Guess it's because ACT! also uses SQL server. 

View solution in original post


All Replies
Bronze Elite Contributor
Posts: 2,115
Country: United_Kingdom

Re: Is there a roll back mechanism in ACT!

Hiya,

 

I haven't checked it myself but I suspect that the Cancel() only works before a call on Update(). 

 

Vivek 

Vivek Gargav
Caldere Associates Ltd.
www.caldere.com
vgargav@caldere.com
My Blog
Copper Contributor
Posts: 16
Country: New Zealand

Re: Is there a roll back mechanism in ACT!

I noticed that as long as I don't call Update(), no changes will be committed to database, so what's the use of Cancel()? is it called implicitly?
Solution
Accepted by topic author zhili
‎09-25-2015 03:20 AM
Copper Contributor
Posts: 16
Country: New Zealand

Re: Is there a roll back mechanism in ACT!

Just found out myself that putting any ACT! database operations within a .NET transaction scope will do the job. Guess it's because ACT! also uses SQL server.