Prevent data modification using trigger
Posted on 2004-11-23
I'm trying to prevent anyone running an update on my table and updating the data in a row if one of the fields is equal to 'Z' if the field is equal to anything else they can do what they like.
Unfortunately I cant think of a way to do this though i have a notion that it could be done with an "instead of update" trigger - however my attempts at doing this have only led to me deleting all my data!!!