I am having a table_A (with PK integer, autoincrement) and table_B.
In table_B I have a lookup from table_A - so in the corresponding field of table_B an integer is expected.
When I create a new record in table_B everything is fine, even when I do not choose anything from the lookup (coming from table_A).
When I edit an existing value in table_B and want to remove the value from the lookup by choosing the empty entry on top the update fails when I press save:
Code: Select all
Incorrect integer value: '{empty_value}' for column 'ID_something_FK' at row 1
SQL-Anfrage:
UPDATE `sometable` SET `xx`='c2', `yy`='c2', `ID_something_FK`='{empty_value}' WHERE `ID`='203'
Can someone confirm this error please? Thanks
Olaf