trskopo wrote:

> 3) change id's column def
> UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = 1
> WHERE RDB$FIELD_NAME = 'ID' AND RDB$RELATION_NAME = 'TEST';

You have to understand that this is a 'hack' that directly updates the systems
tables rather than a managed change to the null flag.
If you are using Flamerobin, then us it's ddl management which would have asked
'what value do you want for nulls' when the flag for the field was changed to
'not null'

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php