Forum | Message

Wed, June, 22nd 2022

1
BC:

Forum Question/Topic:

Article:

Table Triggers

Categorized as:

I am looking for a way to create an Infor Process that will update table fields from one table when another table is updated. To be specific, I want to update the manufacturer fields in ItemLoc (IC81) when the information is changed in ItemMast (IC11). Fields Manuf_Code, Manuf_Division, and Manuf_NBR. I've been looking at the Trigger node and Transaction node but I'm having a hard time figuring out how to use them or even if this is possible. I'd rather not have this be a scheduled processes  Read more...and was hoping there was a way to make this happen when the data is updated.  Show less...
IPA
Delivered Read
1
Bill, are you onprem or in the cloud? If your database is onprem, you could get creative with a database trigger on ITEMLOC. But I think your best bet is going to be to create some user exit code on the IC81 program that will trigger a service in IPA. You should be able to do this from LID (pgmdef), so I think it will work even in cloud. Here is an article I wrote about triggering IPA from 4GL.

 Read more... https://www.nogalis.com/2016/10/31/creating-custom-ipa-triggers-using-4gl/ Show less...

Online