SQLSTATE=23000 (No primary value......)

[bostjan]

When I try to update new value to database table I recieve the next SQLSTATEMENT error:

SQLSTATE = 23000
[Sybase][ODBC Driver]Integrity constraint violation: no primary key value for foreign key 'f_sifra_kupca_popa' in table 'sif_stopnje_ddv'

No changes made to database.

INSERT INTO "sif_stopnje_ddv" ( "tarifa", "stopnja", "opis", "standardna", "sifra_kupca", "sifra_dobavitelja", "konto_kupci", "konto_dobav" ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ? )

 

[rac2]

What is the name of the foreign key column? My guess it is named "sifra_kupca_popa". If so you must include it in the list of columns receiving data and give it a value that matches one of the values in the primary key column.

INSERT INTO "sif_stopnje_ddv" ( "tarifa", "stopnja", "opis", "standardna", "sifra_kupca"

, "sifra_kupca_popa"

, "sifra_dobavitelja", "konto_kupci", "konto_dobav" ) VALUES ( ?, ?, ?, ?, ?

, ?

, ?, ?, ? )