Friday, 15 January 2010

sql - Column 'ID' is constrained to be unique. Value is already present -


I get an obstacle error that I do not understand.

  System Data Constant exception: The column 'id' is constrained to be unique. Value '01d3eb89-f4e1-4782-9519-da8f08e0638f' is already exists  

Let's repeated member data - do not know how it is interrupted me.

query

  select MemberData.UserId, MemberData .FormRow, MemberData.Value where AuthUsers, MemberData (AuthUsers.GroupId = @groupId and AuthUsers.Id = MemberData.UserId and MemberData.FormId = @formId) group based on MemberData.UserId, MemberData.FormRow, MemberData.Value  

AuthUsers a Guid the ASP.NET user table with a group field that is added.

User data is data for form data. It is
FormRow (Guid) - Forms in the form value (string) indicates the line definition line
Id (int) - Unique Auto- increment key
UserId (string) - AuthUser table userId
FormId (Guid) - indicates the form definition form

MemberData
MemberData.UserId Each formRow , the user's form is repeated for data collection.
MemberData.FormRow is every several different User-ID that formRow in FormId of form .
This code has been repeated for each user's data> MemberData.FormId
in the form for every formRow is repeated.
MemberData.Value The entered value is an arbitrary user.

The error is a user id that is repeated in data within that 5 fields 5 times.

I use the member grid summary grouped by MemberData UserId which is the summary row GroupId is used because the summary group Is for all users in

It was a little embarrassing, the message was not from the grid, the database being loaded very confusing, SQL was fixing query problems with very similar messages and the last error message was seen in each other as per the database. The problems in code logic were fixed.


No comments:

Post a Comment