Dear Mark,
Thanks for you info, solved the problem.
Regards,
Anto.
On 2016-06-02 6:20, trsk...@yahoo.com [firebird-support] wrote:
>> What value must it have? Add a default clause to this statement. Or
> add
> > the field as nullable, populate with data and then alter to NOT
> NULL.
>
> I have tried to add field as nullable, then tried to alter to not
> null.
>
>> What value must it have? Add a default clause to this statement. Or add
> > the field as nullable, populate with data and then alter to NOT NULL.
>
> I have tried to add field as nullable, then tried to alter to not null.
>
> UPDATE TMP_RPT SET ID1 = '5'; Commit;
> (This statement is OK)
>
02.06.2016 07:42, trsk...@yahoo.com wrote:
>
> 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.
What value must it have? Add a default clause to this statement. Or add
the field as nullable, populate with data and