Page 1 of 1

Problem in update the record - MySQL

Posted: Thu 01 Nov 2012 18:24
by raynnerdm
Hi, I'm with a problem in update the record in MySQL, every time who I tryed update the record generated an exception indicating duplicate keys.

Best Regards.
Raynner.

Re: Problem in update the record - MySQL

Posted: Fri 02 Nov 2012 15:29
by Pinturiccio
Could you please tell us how exactly you perform the update?
1. Do you use MySqlCommand.ExecuteNonQuery where command text contains an sql update statement?
2. Or MySqlDataAdapter.Update?
3. Or MySqlDataTable.Update?
4. Or another way (please describe it in details)?

If possible, please create and send us a small test project with the corresponding DDL/DML scripts for reproducing the issue.