I have a select (drop down) field configured where users select a name and the respective employee id is written to the mySQL database field.  The database field is set an integer data type.

During normal record editing if I set that field blank the database entry write a Null.

However, if I select ” – Empty – ” during bulk editing it’ll try and set those fields to “” instead of Null, resulting in a incorrect integer SQL error.

Is there a way to ensure the ” – Empty – ” option writes Null values instead of “” for this column?  I’ve tried the isnull column parameter but that doesn’t appear to make a difference.

Thanks.