Microsoft Dynamics AX (Archived)

transaction handling in post event handler in AX7

(0) Share

Report

Posted on by mail2vd

1,330

Hi,

I have an event handler written where i am throwing an error based on condition.

I just want to know whether it would revert the original action which has triggered this event handler? Do I really need to use ttsbegin...ttscommit block in this event handler.

I want the original action to revert whatever it has done if this post event handler throws an exception anywhere in the code. Even I don't want to write try...catch block.

I have written this event handler on the 'updated' event of the table.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

krishna.rao@dax 3,006 on at

Like (0)

Report

Yea, need to use ttsbegin & ttscommit;

like below..

ttsbegin;

//// Business logic

if (condition)

throw error (" transactio reverted");

ttscommit;

Was this reply helpful? Yes No
mail2vd 1,330 on at

Like (0)

Report

What about the event that trigger the event handler?

Was this reply helpful? Yes No
krishna.rao@dax 3,006 on at

Like (0)

Report

I didn't get you.

ttsbegin;

//// Business logic - execution of the business logic

//here business logic may have events or event handlers.

ttscommit;

Was this reply helpful? Yes No
mail2vd 1,330 on at

Like (0)

Report

i have written post event handler on update method of the table which gets executed after update happens on the table.

So just want to know what happens to update method code that has already executed before the post event handler exception.

Was this reply helpful? Yes No
Rob vanBrandenburg 285 on at

Like (0)

Report

Did you find a solution for this? I have a somewhat similar situation where I need to prevent the user from entering a new record from the table.initfromOtherTable() method (post event handler)

Was this reply helpful? Yes No
Martin Dráb 237,805 Most Valuable Professional on at

Like (0)

Report

initFrom* method is a wrong place for validation logic. What about using onValidatingWrite event?

Was this reply helpful? Yes No