Forum Discussion

jesvam's avatar
jesvam
New Contributor III
10 days ago

Sql Table Editor - save nulls

Hi, I have a SQL table with a decimal column that allows nulls, and I want to differentiate between an actual 0 and a null value.

I seem unable to configure the SQL Table Editor in a way that enables me to save a null value. When I press Insert new row, it defaults to an amount of 0.0, instead of null. 

I am aware that I can do a dashboard extender and override the save operation but in this case the column value could be either 0 or null and I wouldn't know how to differentiate between the two. 

Any ideas?

 

User Interface
  • MarcusH's avatar
    MarcusH
    Contributor III
    9 days ago

    You can change the settings for the DB columns on the SQL Table Editor in the SQL Table Editor Column Format section and you might be able to set the Default to DBNull.Value. I haven't tried it but it's the only thing I can think of.