Unable to delete value of a field
Posted: Wed 27 May 2015 12:49
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?
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?