Hi

I have the SQL
Alter table mytable add myfield integer default 0 not null;

This will add the new field, for all existing records populate the
new field with the value 0, but if a insert a new record - through my
app or IBConsole - it forces me te enter a value.

Leaving out the 'not null' allows nulls to be left out.
( I also try default '0' - same effect )
Interbase v6

Any ideas