Problem in update the record - MySQL

Problem in update the record - MySQL

Postby raynnerdm » Thu 01 Nov 2012 18:24

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.
Posts: 1
Joined: Thu 01 Nov 2012 18:12

Re: Problem in update the record - MySQL

Postby Pinturiccio » Fri 02 Nov 2012 15:29

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.
Devart Team
Posts: 2063
Joined: Wed 02 Nov 2011 09:44

Return to dotConnect for MySQL