How about:

SELECT Table_B
APPEND FROM Table_A FOR Table_A.Ident > 10

HTH

>I have two table
>
>TABLE A
>-------
>ident int
>name c
>
>and
>
>TABLE B
>-------
>ident int
>name c
>
>so my code is like that
>
>select * from table_a where ident > 10 into cursor cur_temp
>
>and after that i want to copy line by line into table b
>
>how can i do that ????