Error 194

Message text

No primary key value for foreign key '%1' in table '%2'

Item

Value

SQLCode

-194

Constant

SQLE_INVALID_FOREIGN_KEY

SQLState

23503

ODBC State

23000

Parameter 1

name of the foreign key

Parameter 2

name of the table with the foreign key

Probable cause

You have tried to insert or update a row that has a foreign key for another table, and the value for the foreign key is not NULL and there is not a corresponding value in the primary key