Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (L-S)

 

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

Error constant SQLE_INVALID_FOREIGN_KEY
ODBC 2 State 23000
ODBC 3 State 23000
Parameter 1 Name of the foreign key.
Parameter 2 Name of the table with the foreign key.
Severity 16
SQLCODE –194
SQLSTATE 23503
Sybase error code 546
Probable cause

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