Null vs Empty Value

Applications Forms
#1

I’m using SC9 and MSSQL. When I use SC to insert data, if a field does not have a value, SC insert ‘’ (rather than null). I’m wondering from the experts:

  • should I create a trigger in MSSQL to replace the ‘’ values with null
    or
  • will SC be happier with ‘’ values, and I should leave well enough alone?
#2

Scriptcase has that problem. I reported same bug some years ago. Now if the field is numeric and the value Null, SC replace the value by Zero.
The problem is when the field is foreign key. The database show an error of integrity.

#3

I think SC must have a boolean property for that fields: (Empty if Null) or (Zero if Null).

#4

Thank you alvagar…

I found that I can set the DB value that gets saved in the database to: Calculated by the database if empty

And that gives me a nice null value

1 Like