I came across this condition while at the 2073a class.
Modifying data through views using WITH CHECK OPTION while doing excercise 3 in module 8 prevented updating the supplier id from 14 to 12, as long as it was via query analyzer.
When I went into the EM though, I was able to change the value on supplierid even though with check option shows up as part of the create view statement.
Is this a bug? It baffled my instructor as well!
Modifying data through views using WITH CHECK OPTION while doing excercise 3 in module 8 prevented updating the supplier id from 14 to 12, as long as it was via query analyzer.
When I went into the EM though, I was able to change the value on supplierid even though with check option shows up as part of the create view statement.
Is this a bug? It baffled my instructor as well!
