#716 (ok 4.0) Set auto_increment column to 0

[Eric Krona]

Set auto_increment column to 0 when selecting any of the insert options in the submit_type dropdown.

Solution for feature req ID: 3480477
https://sourceforge.net/tracker/?func=detail&aid=3480477&group_id=23067&atid=377411

[Eric Krona]

[Marc Delisle]

Thanks for your patch.

It works well when editing; however, when inserting, there is one unpleasant effect: I enter a primary key value, then change the selector to "insert as new row and ignore errors" and I lose the value I typed.

[Eric Krona]

Updated patch including fix for problem described by lem9

[Eric Krona]

Added new patch, the one names 0002(!) is the latest one, try that instead.

[Marc Delisle]

Merged, thanks. See my commit 7b5c5f902eb1f0f0a17d5193459727c1abb7fa77 for minor code cleanup.

Also, it does not work in the "with selected... change" dialog so it could be improved.

[Eric Krona]

Fixed with selected problem

[Eric Krona]

See latest patch, with_selected_auto_increment_auto_0_20120204_v2.patch which makes it work with the "with-selected...change"-dialog. A bit better and cleaner code as well.

[Marc Delisle]

Eric,
with latest patch applied on current master, I have this problem
1. browse a table
2. click on edit for a row
3. choose "insert as new row": the PK is not set to 0