Search the Community
Showing results for tags 'update set'.
Found 1 result
-
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; Any help appriciated
