Bug #11626 Editing field twice before saving results in error
Submitted: 29 Jun 2005 1:37 Modified: 29 Jun 2005 1:45
Reporter: Mark McAulay Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.10 OS:Windows (Windows 2000)
Assigned to: CPU Architecture:Any

[29 Jun 2005 1:37] Mark McAulay
Description:
After performing a query, then clicking on the edit button, I edit a field in a NEW row. If I happen to make a mistake in the field and go to edit it again BEFORE applying changes, it adds the field twice to the underlying SQL, meaning that the SQL has an error and that the changes can't be applied.

This sometimes results in an Access Violation as well but I haven't been able to reliably repeat that.

Thanks,
Mark.

How to repeat:
Try adding a new record to a table by using the editing in QB. If you edit the field twice it will give you an error saying the field was specified twice.

Suggested fix:
Ensure the underlying INSERT statement specifies fields once, regardless of how many times they are edited before applying changes.
[29 Jun 2005 1:45] Mark McAulay
Whoops, this is a duplicate of the following:

http://bugs.mysql.com/bug.php?id=10270
http://bugs.mysql.com/bug.php?id=11241