Updating/Deleting Data in Views in SQL

[RocAFella2007]

Hi, I was oping somebody could help me out please. I have created a view which joins 3 tables, the view itself works with no problems but im facing problems when it comes to the data getting edited, updated or deleted in the view.

The error message that appears when i try to update is:

ORA-01779: cannot modify a column which maps to a non key-preserved table.

The help i require is if somebody could tell me how you actually update/delete records in the view I would appreciate it. Thanks.

 

[PHV]

1) do a google search
2) post in an Oracle forum

 

[JarlH]

Probably the DBMS can't decide which base table data up update. (Instead of manipulating the view, work directly on the base tables.)