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

>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.

At what point are you getting this error? Can you post the stack trace?

Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform