Jeff,
>I am using an mmPicker control to display inventory items for the user to select. Obviously, I don't need all the gory detail and since there is a lot of data, I just want to return the relevant columns. When I click the query button on the control, I get a "Failed to enable constraints..." error. I tried setting EnableConstraints to false for the business object dataset, but I still get the same error.
>
>As I was trying to figure out where the dataset was coming from, I traced into HookGetPickListData() and as I followed it, it creates a new DataSet not related to the original business object (makes sense). However, when this dataset is created, I don't see a way to have it ignore the constraints.
>
>Am I missing something?
This typically occurs when there are constraints on a column and you are retrieving data that violates the constraint. Here is a link with some good things to try:
http://weblogs.asp.net/rosherove/archive/2004/10/03/DataSet-hell-_2D00_-_2200_Failed-to-enable-constraints.-One-or-more-rows--contain-values_2E002E002E002E002200_.aspxBest 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