Why is OnAfterInsertEvent subscription triggered (twice) when opening a sales order?

markcle

Hi All

I have a code unit that has this line in it:

 [EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnAfterInsertEvent', '', true, true)]

It fires twice for every line when I open a sales order and the lines are displayed

Puzzled

Mark

Juhl

If not Rec.istemporary or RunTrigger then
Exit;

It also fires when run trigger is false. So check that as well.

Juhl

Maybe temporary table is in use??

markcle

Juhl wrote: »

Maybe temporary table is in use??

Possibly, but it's a subscription on Sales Lines (Database::"Sales Line"), so shouldn't generate events unless sales lines are inserted

Juhl

It does.
Thats why you ALWAYS check if its temporary, before running your code!!

markcle

Juhl wrote: »

It does.
Thats why you ALWAYS check if its temporary, before running your code!!

Thanks for reply. Still puzzled why the event would trigger on a temp table. how do I check if it's a temp table?

Juhl

If not Rec.istemporary or RunTrigger then
Exit;

It also fires when run trigger is false. So check that as well.

markcle

Juhl wrote: »

If not Rec.istemporary or RunTrigger then
Exit;

It also fires when run trigger is false. So check that as well.

Could you explain a little more about the run trigger issue?

Juhl

Insert(false)
Insert(true)