>Hi all
>Help please!
>

create cursor kids (id i)
>alter table kids add column idi n(5.2)
>append blank

>Why cant I enter 99.9 in idi column (only integer)?
>Thanks

You want a comma in the idi field between 5 adn 2 not a decimal. Also if you just want one decimal it should be N(4,1)

create cursor kids (id i)
alter table kids add column idi n(5,2)
append blank