I have found a bug.
catIDint(11) NOT NULL AUTO_INCREMENT,
namevarchar(25) NOT NULL,
(1, 'Category 1'),
(2, 'Category 2');
CREATE TABLE IF NOT EXISTS
itemID int(11) NOT NULL AUTO_INCREMENT,
catID int(11) NOT NULL,
name varchar(25) NOT NULL,
PRIMARY KEY (
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
(1, 1, 'Item 1'),
(2, 1, 'Item 2');
items_ibfk_1 FOREIGN KEY (
catID) ON DELETE CASCADE ON UPDATE CASCADE;
I edit an entry. I click on the cell an now I can edit it directly (Screenshot 1)
I wrote the number 3 in it, buw 1 and 2 are possible (reference to table 1)
If I save it now, I can see two bugs:
3.1: The query is to long and the dialog to small
3.2: The dialog is above the text field and I can't edit the wrong value. (Screenshot 2)
The only way: Close the browser and start from beginning. Maybe you can make the dialog above the table or so.
I hope you understand what I mean.
THANKS in advance!