Allow Null question

Classic Servoy
1

I’m a newbie, so here goes possibly a dumb question.

I have several text columns that currently say allow null.
I need to column to be NOT NULL with a default of an empty string (instead of NULL).

How do I do that inside of Servoy? I can’t unclick the button. What am I doing wrong?

2

Servoy has a general tool built in for creating/editing tables but it’s not perfect. It’s pretty much there for only adding an occasional column.
You better use a tool that is specially for your database back-end.

What tool that is depends a bit on your database.
if you use Sybase then use SQL Anywhere. If you use MySQL you can use for example phpMyAdmin (webbased).
If you use PostgreSQL you can use for example phpPgAdmin (webbased).
Etc. etc.

Hope this helps

3

Once you have saved a new column to a table, you can’t modify it. You have to create a new column, copy the values over to the new onw and delete the old one.

4

FYI: The underlying reason why you cannot edit existing columns the way you want is that changing a column from “Allow null” to “Not Allow null” can create a database integrety conflict, because there might allready be records in the table with a null value in that column.

So it a dellibarate feature :)

Paul