Why are you using a temporary table at all? Do you have a need for the middle table? If not, you could:
SELE tablea
Scan ALL FOR tablea.indent > 10
Insert Into tableb (indent, name) values (tablea.indent, tablea.name)
EndScan
>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 ????
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"