On Thursday, January 26, 2006, 6:39:19 PM, You wrote:

> Hi,

> What is the command to change the
> column to NOT NULL ?

> alter table TEST
> alter f3 type decimal(18,7) NOT null

> but still hit an error ..
> please help

> Regards
> Teh


Try this
update RDB$RELATION_FIELDS set
RDB$NULL_FLAG = 1
where (RDB$FIELD_NAME = 'F3') and
(RDB$RELATION_NAME = 'TEST');

for safety, make sure all record in that field have a value (not
null).


--
Best regards,
Andi Wangsadijaya

Send instant messages to your online friends http://asia.messenger.yahoo.com