Set blank values to '' or null in Edit SQL.
Mydb.dbEditAllowZeroLength = "True | False(Def)"
This boolean property is for Editing operations. If your db allows zerolength fields then a blank '' will be used in the SQL. Otherwise a 'null' will be used. The default is to use 'null'. This is one of those tiny option that can break you if you do not have it.