This error means that m.no is not of the expected type. Because of the previous code, m.no is already of type numeric. Just omit the val() function.

On the contrary, I think you have to convert back to character, to save to the field, which seems to be of type character. In this case, you can use the str() function or the transform() function.

>hi all,
>
>any idea,help
>
>i try to choise fields from mytable to insert it to new table as under,
>i get error message syntax error
>

>USE am2
>scan
>m.char1=char1
>m.char2=char2
>m.char3=char3
>m.char4=char4
>m.char5=char5
>m.char8=char8
>
>
>       USE home
>
>m.no=val(list_no)+1
>
>       APPEND blank
>
>       replace customer_tel WITH m.char8
>       replace home         WITH m.char2
>       replace qdate        WITH m.char3
>       replace name         WITH m.char4
>       replace account      WITH m.char5
>       replace bus          WITH space(10)
>       replace survey_no    WITH space(10)
>       replace list_no      WITH val(m.no) && error messageFunction argument value, type, or count is inval
>       replace flag         WITH 0
>       replace n_try        WITH 0
>endscan
>

>thanks