>Thanks, I thought this sounded like a familiar problem!
>
>>Check your older thread on this topic
Failed to enable constraints Thread #
1495470 Message #
1495470>>May be it will help.
>>
>>>To be honest, I don't know and don't know where to look or how to check. All the data set stuff is hidden by the Mere Mortals framework, I just tell it what stored procedure to run and it creates the dataset.
>>>
>>>>Does your DataSet has properly defined Primary Key?
>>>>
>>>>Also, I believe we discussed this exact error about a month or so ago with you before.
>>>>
Frank,
Were you able to figure this out? Usually, I run into this when building a dataset for a report where there might be duplicate keys and I don't really care. I generally either add another column based on the ROW_NUMBER from SQL or create a new dataset and use the following code:
DataSet ds = new DataSet();
ds.EnforceConstraints = false;
this.FillDataSet(.....);
this.SetCurrentDataSet(ds);
I have only used the latter option when creating a dataset for reporting, which I do in a generic business object.
Linda
Linda Harmes
HiBit Technologies, Inc.