Error 194

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

Item Description

SQLCode

-194L

Constant

INVALID_FOREIGN_KEY

SQLState

23503

ODBC 2 State

23000

ODBC 3 State

23000

Sybase Error Code

2125

Severity Code

16

Parameter 1

Name of the foreign key.

Parameter 2

Name of the table with the foreign key.

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


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com