Unable to delete value of a field

[Alan Cossey]

Hi everyone, this is my first time here. I am trying out dbForge Studio for MySQL as well as making my first forays into MySQL. I'm an Access developer (18 years) with some SQL Server/Azure experience.

I have imported some tables from SQL Azure into MySQL, which has gone OK. In one table, I am looking at the values using "Retrieve Data" (not read-only). I am able to change the value of a particular field in the table (tblFranchises) to any numerical value I like (it being Int(10)). It is not a foreign key. It allows nulls and the default value is NULL. However, I cannot delete that value. When I try I get the message,

Value '' is not valid.

I am currently trialling dbForge Studio for MySQL and all has gone exceedingly well so far apart from this one thing. Note that I am also trialling NavCat and I can delete the value with no problem in NavCat.

What am I doing wrong, please?

[alexa]

Please use the 'CTRL+0' key combination or right click the cell and select 'Set VAlueTo -> NULL' from the popup menu.

[Alan Cossey]

Many thanks.