OnInserting not firing on a table

(0) Share

Report

Posted on by DanAx

I've added a few fields through a table extension, when a record is inserted into the table I want to populate those fields with some data prior to the insert.

I've created a static class and added the event to it, but it doesn't fire, My breakpoint in visual studio never gets hit and the data doesnt show up in the table. I've done all of the normal, database sync, reboot, etc.

static class MyRetailGiftCardTransactionsEventHandlers

{
[DataEventHandler(tableStr(RetailGiftCardTransactions), DataEventType::Inserting)]
public static void RetailGiftCardTransactions_onInserting(Common sender, DataEventArgs e)
{
RetailGiftCardTransactions r = sender as RetailGiftCardTransactions;
r.myCustomField ='1234';
}

}

Anyone have any input?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Mea_ 60,284 on at

Like (1)

Report

Hi Daniel Budimir,

Thats probably because retail guys do not like inserts, they do "doInsert" because of some strange reason, so your event won't be triggered. You need to find a place where record gets inserted into DB and add your code there, it could be multiple places, cross references and debugger will help you. One of them is RetailGiftCardTransactions::add().

Was this reply helpful? Yes No
DanAx on at

Like (0)

Report

Thanks for answering ievgen, I can get a prehandler for the add method but that doesn't buy me much as far as I can tell. Any other suggestions? I'm calling retailtransactionservice which in turn calls retailtransactionservicetransactions so I'm having some trouble getting to that object.

Was this reply helpful? Yes No
Verified answer

Mea_ 60,284 on at

Like (0)

Report

You definitely need to go back to MS and ask for extension points. That is the issue they have and they need to fix it. As a stupid work around you can do post handler to RetailGiftCardTable::createCard, set the fields and call update, it's extra DB call but you have no other choice.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hello

I also had this problem but fortunately solved it.

You can use the following:

"ttsbegin;

r.myCustomField ='1234';

ttscommit:"

Was this reply helpful? Yes No