Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MmDataAccessSql throwing an error.
Message
De
03/08/2009 16:00:16
Timothy Bryan
Sharpline Consultants
Conroe, Texas, États-Unis
 
 
À
03/08/2009 15:32:19
Tegron Tegron
Platinum Technologies
Ohio, États-Unis
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Versions des environnements
Environment:
ASP.NET
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01415935
Message ID:
01415940
Vues:
46
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform