>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 ????
If you are using VFP 8 you can use the new
INSERT INTO table_b (ident , name) ;
SELECT indent, name FROM table_a WHERE ident > 10
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers