Table editing in IDE

  1. create a new table and save it
  2. edit the table (delete columns, etc…)
  3. then, when adding new columns, the IDE does not permit un-ticking of the ‘Allow Null’ property

because in an existing table you can’t easily create an extra column where allow null is false
Because what values should then go into the existing rows?

Johan,

But Servoy does not first verify whether the table contains data…

Maybe this would be usable when the column has a default value (say 0 for NUMBER, or ‘Y’ for TEXT) than Servoy can update the column and use the default value for all rows that have a NULL value.