Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Failed to Enable Constraints
Message
From
29/11/2006 16:18:01
Jeff Corder
Ambit Technologies, LLC
Missouri, United States
 
 
To
All
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Title:
Failed to Enable Constraints
Environment versions
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01173507
Message ID:
01173507
Views:
58
I am getting an error:

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

when read I GetDataSet() for a view. The view is a composite of several tables (primarily Inventory and Units Of Measure). There is no primary key for the view (although I tried adding one and nothing changed) and in this instance, almost all of the columns are identical. I checked and verified I do not have any duplicate field names (I don't think SQL would have allowed it anyway).

I set the business object's PrimaryKey = "". This made no difference.

Any assistance would be greatly appreciated.

Jeff
Next
Reply
Map
View

Click here to load this message in the networking platform