AnsweredAssumed Answered

Sugar 6.5 form won't save null values

Question asked by gperez gperez on Sep 16, 2014
Latest reply on May 8, 2015 by Keyun Shang
Hi

We are running Sugar 6.5.x CE

When editing a form and saving a price with null value (null, not cero) Sugar refuses to store the record. Why? DataBase definition for this field accepts null as value.
 
There's no logic hook and no controller logic implicated. It's just that when saving the form with that field empty (actually, they are more than one with this issue and they are all defined as 'double' in mysql) the field with null value is being skipped (it's not being included in the mysql statement).

So, I'm a bit lost. Can't find info on this on the web.

Any clue?

Outcomes