Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Failed to enable constraints

Author  Topic 

Swati Jain
Posting Yak Master

139 Posts

Posted - 2006-10-07 : 10:16:11
Hi,

when i was using master details using gridview-detailsview i got this error how to solve it?

"Failed to enable constraints. One or more rows contain values violating
non-null, unique, or foriegn-key constraints."

swati

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-10-07 : 10:39:10
Check which column / record is violating the constraint. Modify the value


KH

Go to Top of Page

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-10-08 : 02:21:53
While adding the records in the master table, some of the values in the secondary table must be getting affected.

Check out the foreign keys associated with the master table.

Also check if there is any trigger written on the master table.

Chirag
Go to Top of Page
   

- Advertisement -