Error -1225 during conversion OnLine 5.01
Hi,
Another curiosity !!
If I...
create table t1 ( fld1 decimal (8) not null );
insert into t1 values (0) ; commit work ;
alter table t1 modify (fld1 char(8) not null) ;
I get error -1225 ( column does not admit a NULL value)
I know I can alter to char and then alter to not null,
I also know that if the first record does not contain 0
the original alter works fine.
Why does it do that ?
Tom Hogarty <Standard Disclaimers Apply>
SNI OnLine 5.01.U
Germany ANSI Mode Database
Tel : +49 52518-11602
Fax : +49 52548-27905
E-mail : hogarty.pad@sni.de