I have developed an application with OutSystems where I have an entity attribute whose data-type is integer . the acccepted range of this integer in -999 to 999 or Null
Question 1) When I assign Null to this integer and store it into the database it gets stored as 0 by default. How do I prevent this from happening.
Question 2) when I assign Null to this integer(in preparation) & open up that particular form for editing purpose the entity attribute being of integer type the value in that textbox is displayed as 0(zero). I would like to see a clear(blank) textbox.
In Input properties of the text box I tried setting Null Value to TextToInteger("") - this resulted in a complication. When the value of the integer is actually 0 , the textbox still displayed a clear(blank) text box
Do let me know if any part of the question isn't clear