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
Thanks It worked for me.
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.
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;
Yes I tried but it's not working.
Did you try adding the Field and then building your solution?
Otherwise your could do this
TableBuffer buffer = Table.orig(); // now use buffer.Field
Hi,
MyTable.Field = MyTable.orig(). ;
Cannot find Field after orig() method.
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.
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.
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.
#1
André Arnaud de Cal...
293,245
Super User 2025 Season 1
#2
Martin Dráb
231,925
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
