Previous Topic Next topic Print topic


X229: The insert/update value of foreign key name is invalid.

An UPDATE or INSERT operation attempted to place a value in a foreign key of the object table; however, this value was not equal to some value of the primary key of the parent table.

When a row is inserted into a dependent table, the insert value of a foreign key must be equal to the value of the primary key of some row of the parent table in the associated relationship.

When the value of the foreign key is updated, the update value of the foreign key must be equal to the value of the primary key of some row of the parent table of the associated relationship.

Examine the INSERT or UPDATE value of the foreign key first, and then compare it with each of the primary key values of the parent table to determine the problem.

Previous Topic Next topic Print topic