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