Problem in update the record - MySQL

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Posts: 1
Joined: Thu 01 Nov 2012 18:12

Problem in update the record - MySQL

Post by 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.

Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Problem in update the record - MySQL

Post by 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.

Post Reply