Management of a number field

Scriptcase 8 Discussion
#1

Good morning, I have a problem on the management of a number field.
I summarize the situation and scenarios.
DB - Oracle
Numeric field name : Azimut.
Allowed values 0 to 359.
The field is not required.

  1. Field Setup in case of no enhancement. I set null
    Result.
    If I enter the field value of 0 on the database stores null (verified on table ).
    This is not good because the field can take the value 0.

  2. Field Setup in case of no enhancement. No setting
    Result.
    If I enter the field value of 0 on the database stores 0, verified, it would be fine.
    If the field does not I enter anything on the database stores equally 0, occurred, not good, it should leave it blank.
    As I said the field is not required, so may seem enhanced.

I do not know how to solve it, unfortunately a variable is considered empty if it is:
? empty string;
? numerical value of 0;
? array with no elements;
? NULL;

Thank you

#2

That error was reported some months ago, and now continue. Please Fix The error SC Team. That problem happens Too when the field is Foreign And SC Changes the value of NULL to ZERO, the form does not allow saves changes!

#3

Unfortunately my problem is unresolved.

My problem is how to handle a numeric field that can take the values 0, blank or greater than 0. The field is not mandatory.
the problem that 0 and null are considered equal. For me 0 is a valid value, while null means not valued.

#4

Resolved with the latest version.
Now stores null and 0 correctly.