Hi!
I apologize for the bulky title. I've got a View which consists of a table of my order-lines and a view which consists of my articles. It looks like this:
SELECT
Orderline.PK_OrderlineID
,Orderline.FK_OrderID
,Orderline.FK_ArticleNo
,Article.Info
,Article.Distributor
,Article.Price
,Orderline.amount
FROM Orderline,Article
Where Orderline.FK_ArticleNo=Article.PK_ArticleNo
Now I would like to execute inserts/updates/deletes in the View. But of course only the part of the View which consists of the Orderline-Values. (Btw: PK_OrderlineID is an identity).
But of course this kind of Insert-Statement is invalid due to not all columns are updated.
I searched quite long on the Internet to find something. Most pages refer to the case where both parts of the view need to be updated... Someone had an extraordinary interesting idea: To delegate this stuff to a ...
Go to the complete details ...