Yes, I understand, this is for test only.

Thanks and regrads,
Sugiarto

--- In firebird-support@yahoogroups.com, Lester Caine <lester@...> wrote:
>
> 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
>