iAnywhere.com - No primary key value for foreign key '%1' in table '%2'

SQL Anywhere® 10 - Error Messages > Database Error Messages > Alphabetic list of error messages

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

Item	Value
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