>is this code correct mean type of field....list_no N(10),

I'm not sure I understand your question.
list_no N(10) && Numeric with 10 digits wide
list_no N(10,2) && Decimals
list_no i && Integer

>hi,
>thank you for reply,
>
>is this code correct mean type of field....list_no N(10),
>
>thanks
>
>>Since you are creating a free table (not part of a database) the field lenght limit is 10 (Your field customer_tel has 12). Try using a shorter name.
>>
>>>hi all,
>>>
>>>i try to create table , some fields as number(numaric)TYPE
>>>

>>> CREATE TABLE home(list_no N(10), customer_tel C(15),name C(80), area_no C(10),account C(10), qdate C(30),home C(10), bus C(40),survey_no c(10), flag N(10),n_try N(10)  NOCPTRANS)
>>>

>>>THANKS