Capture a changing in a table

[Former Member]

Hi

How can I capture a changing in a table?

I have triggered an event and associated it to a job. In other words the event have to be raised from a changing in a table.

Regards.

Angela

[Former Member]

Hi Angela

What does Changing in a table mean for you?

Do you mean your job should be triggerd as soon as a modification is done in a table of database?

Max

[Former Member]

Yes Max,

my job should be triggerd as soon as a modification is done in a table of database!

How can I do?

Thanks

Angela

[mithun_shetty4]

You need to check the "Change document Tab" in the Data element tab of the Field that u want to Capture .

The change will be stored in CDHDR and CDPOS tables .

Award if Helpful.

/M

[Former Member]

Hi

If it's a custom table the easy solution is to change all programs update it in order to raise the event.

If it's a std table you should check if u can use the events triggered when a change document is created, but I believe you need a Workflow here.

U can try to create a little program to check all change documents and if there are some modification it'll raise the events.

Max