I have a newbie issue when trying to update two fields. The two field have a trigger in the database that says that if one is set, the other one most also be set (both ways). So the following code gives me an error because it won't set both fields before storing the data.
UPDATE xx.emne eSET e.ARSTALL_EKS_SISTE=2015, e.TERMINKODE_EKS_SISTE = 'HØST'WHEREe.EMNEKODE like '%FRIE%'and e.ARSTALL_EKS_SISTE IS NULL;
Update fields that are depending on each other
in SQL
Posted
I have a newbie issue when trying to update two fields. The two field have a trigger in the database that says that if one is set, the other one most also be set (both ways). So the following code gives me an error because it won't set both fields before storing the data.
Any help appriciated