cancel
Showing results for 
Search instead for 
Did you mean: 

Triggers - Need to modify column before an update

tjhastings
Explorer
0 Kudos

Hi Im having an issue, we have a consolidated database that is being updated via dbRemote, however the branch code has to be modified before data is inserted to provide a unique solution. This works fine with insert. However on Update there is an issue the update that is sent down has the original branch associated so the update is fired. How do I get around this please .

former_member182948
Active Participant
0 Kudos

Hello Terry,

Your explanation sounds like to change the data of the key column.

Is my understanding correct?

Best Regards,

Accepted Solutions (0)

Answers (2)

Answers (2)

tjhastings
Explorer
0 Kudos

For further information the branch column is a part of the key

chris_keating
Advisor
Advisor
0 Kudos

Can you walk us through the operations and desired outcome on both the consolidated and remote database. Please include the trigger logic that has been implemented so that we know what the trigger is attempting to do..

tjhastings
Explorer
0 Kudos

That should have read 'the update isn't fired'