larsvemund Posted June 26, 2015 Share Posted June 26, 2015 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 Link to comment Share on other sites More sharing options...
justsomeguy Posted June 26, 2015 Share Posted June 26, 2015 You might be able to wrap that in a transaction to fix that. 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now