Hi guys,

I have a table with existing data & got a problem to add field that must have a value -> alter table Tbl1 add Fld1 int not null.

If table doesn't have data, it is OK, but Firebird refused if table already have data. Any suggestion how to solve this problem?

Thanks & regards,
Anto