Sql Exception

[Suresh Pirsquare]

When i try to insert a record in my webapplication,it is giving the Following Error: INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_Client'. The conflict occurred in database 'sam', table 'ClientStatus', column 'client_id'. The statement has been terminated. I want to know why it is giving this error and how to resolve this error. Thanks in Advance, Regards, Suresh Dayma

[Colin Angus Mackay]

Suresh Dayma wrote:

I want to know why it is giving this error and how to resolve this error.

Because you have related tables. The insert breaks the relationship in some way. There is other data (probably in a table called Client) that needs to be inserted first.

---

Upcoming Scottish Developers events: * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos

[MoeInsairat]

hey, it's all about the relations in ur DB. for sure u r having a releation between the clientstatus and client_id and the primary key in the client_id doesn't exist in the other table. i mean the value.

Estarta