hi!
afaik you cannot add a not null column to a table because (in a table where there is already some data) the field values are null. the option to add a not null column perhaps only works on an empty table with no rows yet. so this behaviour is expected.
therefore you need to add a column, update the table to set the column values so there is no null fields and then you can alter the column to set it a default value, then again to set it no null. this always worked for me.
Sorry, I wasn't clear. This is an empty table. After creating it, I wanted to add some more columns. I used the properties of the table to try adding them but this failed. I then went to the column view and added them one at a time and that worked. This behaviour is inconsistent and should be fixed. There was no data in the table when I did this.
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
