rahma.affes
Member
Hello,
I need to modify the MCU of the table F060116 in each insert or update of this table.
So, I created a function that can recover the MCU from other fields.
I called this function in the trigger of this table to modify the value of TK MCU with the new recovered.
This function is functional in the event Before record is inserted and not functional in before record is updated.
Do you have please any idea about this problem knowing that normally the modification of the MCU is only done for the modification of one of the 4 fields and I could not know how to recover the values before the update to make the comparison with the news values to do the test.
In advance thank you.
I need to modify the MCU of the table F060116 in each insert or update of this table.
So, I created a function that can recover the MCU from other fields.
I called this function in the trigger of this table to modify the value of TK MCU with the new recovered.
This function is functional in the event Before record is inserted and not functional in before record is updated.
Do you have please any idea about this problem knowing that normally the modification of the MCU is only done for the modification of one of the 4 fields and I could not know how to recover the values before the update to make the comparison with the news values to do the test.
In advance thank you.