Show TOC

-8035: Foreign key must existLocate this document in the navigation structure

Use

Explanation

An UPDATE statement was issued on an updateable join view table. This UPDATE statement leads to an internal insert into one of the underlying base tables. The specifications made in the UPDATE statement are not sufficient to form all mandatory columns which are needed for the implicit INSERT statement.

User Response

Issue an INSERT statement on the underlying base table. This can prevent the necessity of inserting when performing the UPDATE statement on the join view table.