Re: Autoincrement fields not recognised as Autonumbers

[Andrew Dixon]

I have but it still doesn't work flawless (i.e. the deleted issue still crops up now and again).

Essentially all you need to do is trap the CTRL+V Keypress, in the forms keydown event, parse the clipboard (data is just stored as TAB/CR separated values) and then use code to addnew lines to the required tables.

Incidentally though, the whole problem can be averted if a blank line is inserted, and then data is pasted into the new blank line ~ Not an ideal workaround, but nothing involving the MySQL ODBC Connector seems to be.