Mysql update statement broken

Question

0.00/5 (No votes)

See more:

hi everyone here is my code but i keep getting the following error

XML

Duplicate entry 'ACSA-b-a' for key 'PRIMARY'<pre lang="sql">MySqlCommand sqlcom = new MySqlCommand(&quot;UPDATE t_groups SET Groups=@Groups,Description=@Description,Shared=@Shared  where User_Name =&#39;&quot; + userName + &quot;&#39;and Company_Name=&#39;&quot; + CompanyName + &quot;&#39;&quot;, mycon1);
            sqlcom.Parameters.Add(&quot;@Company_Name&quot;, MySqlDbType.VarChar, 100).Value = lblEditcompany.Text;
            sqlcom.Parameters.Add(&quot;@User_Name&quot;, MySqlDbType.VarChar, 100).Value = lblEditUserName.Text;
            sqlcom.Parameters.Add(&quot;@Groups&quot;, MySqlDbType.VarChar, 100).Value = txtEditGroup.Text;
            sqlcom.Parameters.Add(&quot;@Description&quot;, MySqlDbType.VarChar, 100).Value = txtEditDescription.Text;
            sqlcom.Parameters.Add(&quot;@Shared&quot;, MySqlDbType.VarChar, 100).Value = DDEditShared.SelectedValue;

            this.ModalPopupExtenderEditGroup.Hide();
            sqlcom.ExecuteNonQuery();</pre>

the value of Company_Name = Acsa and the value of user_Name = b and the value of Groups is a i am only updating the value of description
my table has three keys Company_Name,User_Name ,groups please help me i can insert and delete fine but its my update that breaks

Posted 31-Oct-12 3:33am

mrDivan

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

fjdiewornncalwe · Answer 1 · 2012-10-31T03:40:00

Solution 1

If you are getting a "Duplicate Entry" error, then you have a problem with the data you are feeding in.
I think your issue is in the way you define your primary key on your table. Why on earth would you include groups in your primary key?
If you remove the Groups column from your primary key your query will work.

Posted 31-Oct-12 3:40am

fjdiewornncalwe

Comments

mrDivan 31-Oct-12 10:12am

Hi marcus my other table depends on it to be a primary key the group table has 5 columns company_Name pk,user_Name pk,groups pk, description,shared
the table has many to many relationship to my other table which has the following columns company_Name pk user_Name pk,groups pk, cellNo pk ,title,name ,ref
the 1 table has foreign key relationships to the first tables primary keys

fjdiewornncalwe 31-Oct-12 10:33am

It appears that you have a serious issue with the normalization of your database which is going to make things difficult for you. If you find yourself repeating multiple similar columns in different tables, then you are not normalized. The primary tables should be assigned an id with a unique constraint added to the applicable other columns so that you only need to have the primary id referenced from tables that need it.