|Subject||Re: FB 3.0, got problem when add field to Table with existing data|
> What value must it have? Add a default clause to this statement. Or addI have tried to add field as nullable, then tried to alter to not null.
> the field as nullable, populate with data and then alter to NOT NULL.
UPDATE TMP_RPT SET ID1 = '5'; Commit;
(This statement is OK)
UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = 1
WHERE RDB$FIELD_NAME = 'ID1' AND RDB$RELATION_NAME = 'TMP_RPT';
(This statement raised an error, FB 3.0 doesn't allow SysDBA user to change System table)