Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MmDataAccessSql throwing an error.
Message
From
03/08/2009 16:00:16
Timothy Bryan
Sharpline Consultants
Conroe, Texas, United States
 
 
To
03/08/2009 15:32:19
Tegron Tegron
Platinum Technologies
Ohio, United States
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Environment versions
Environment:
ASP.NET
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01415935
Message ID:
01415940
Views:
47
>I am getting the following error: Column 'CheckItemID' is constrained to be unique. Value '1' is already present. This error is being generated by the following command in the mmDataAccessSql method:
>
> RowsUpdated = DataAdapter.Update(ds, ds.Tables[tableName].ToString());
>
>I am using the command --> mmSaveDataResult resultCRI = this.ri.SaveEntityList(); to update 258 items to a table. I generated the business object with the BLG, so it is automatically numbering each entity. So I don't understand why it would say that this field needs to be unique, when it is doing the actual generating of the key value. The field is setup as an identity field on the backend. Does the business object entitylist support 258 entity items? What would cause an auto incremented field to throw this error?

What happens when you try to save a single record to the same database table? I am not aware of a limitation on the EntityList and I suspect something else.
Tim
Timothy Bryan
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform