Regaining Original values that a record has before the update is done in dynamics 365

(0) Share

Report

Posted on by Tanmay Upgade

290

Hi Experts,

In my line table having five lines with Quantity field, I'm updating these lines field to zero. If any one of line getting error(suppose line 3)

so I want to cancel this update and regain original values of the lines. Can any one suggest me about this.

Thanks

Tanmay

Categories:

Development / Customization / SDK

I have the same question (0)

All responses (10)

Answers (2)

Suggested answer

Mea_ 60,284 on at

Like (0)

Report

Hi Tanmay U,

If you updating them from code then just use transaction wrapping all updates with ttsBegin; ttsCommit; In this case error inside of the transaction will rollback all changes.

Was this reply helpful? Yes No
Tanmay Upgade 290 on at

Like (0)

Report

Hi ievgen,

I am trying to use orig() method to get the previous state of field but its not happening in D365 and same is working in AX 2012.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi TanmayU,

You are on the right path and orig() is the solution to your problem, just call it when an error occurs to update the value. or you could achieve this manually by keeping a copy of the reference at the start of the operation and update your value with that copy when an error occurs.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

You can use orig only before super() of update, where do you have it ?

Was this reply helpful? Yes No
Tanmay Upgade 290 on at

Like (0)

Report

Hi,

MyTable.Field = MyTable.orig(). ;

Cannot find Field after orig() method.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Did you try adding the Field and then building your solution?

Otherwise your could do this

TableBuffer buffer = Table.orig(); // now use buffer.Field

Was this reply helpful? Yes No
Tanmay Upgade 290 on at

Like (0)

Report

Yes I tried but it's not working.

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (1)

Report
What exactly is not working? Please share more details.

The .orig() returns and object of type Common so it doesn't contain references to your fields. Instead you must do like Danyal already instructed:

YourTable yourTable_orig = this.orig(); [...] yourTable.YourField = yourTable_orig.YourField;

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Attach the debugger and make sure that the orig() record is committed to the database before the error is thrown. The orig() should return the values that were at the start of the operation rather than the updated values. Make sure you are properly terminating your transaction via the ttsCommit keyword.

Was this reply helpful? Yes No
Tanmay Upgade 290 on at

Like (0)

Report

Thanks It worked for me.

Was this reply helpful? Yes No