Null for integer data type when update dbb with "calculated by database if empty"

Scriptcase 9 General
#1

Hello,
In my mysql db, i use for integer null by default.
In SC, in form application i use “Calculated by database if empty”

Works fine when field is null.
Works fine when i change value to any integer.
But when i suppress value in form (field is empty now). Field not change. Impossible to suppres value, he keeps the last value. In debug mode, the field doesn’t appears in update command sql.

Resume when i enter or not a value : works fine. when i suppress value, field is now empty, doesn’t work.

SC v9.5.003

Thanks
Guy

#2

This is a BIG problem also for us.
I’ts impossible to define a condition like “NULL if empty”. The only workaround is to check by code in On Before Update event and eventually assign NULL value to a field (!)