When I have a field in my database of type DECIMAL… Scriptcase wants to always enter a value in it. If I leave the field blank it puts in a 0… I dont want that I want the field blank when its blank.
Some fields don’t need a value… and 0 is a value.
How do I allow fields in the database to remain blank or empty?
i allow NULL for value when i do not have 0; just {field} = NULL;
I know what you mean. I have an integer field that gets set to 0 when it is really null, when the form is opened and saved. I know we can force a null on saving, but it always displays as zero. Need an option that would display as NULL or not set or something, instead of 0,.
This is a MYSQL tweak. Set the field to allow IS NULL.
I do have those fields in the DB set to allow NULLs. The problem is the field in the SC form has no such option. If it is an Integer field, it will put a 0 in the field for a NULL value, then when saved, it is stored as 0. I want to be able to tell if a field was not filled out by the users, but can’t because essentially SC is filling it out for them as 0.
I did not have that situation, but I would think that the value of the default field in the database must be NULL, and then in scriptcase have the option in EDIT FIELDS - DB VALUE(insert): Calculated by the database if empty