Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy table line by line
Message
From
30/10/2003 12:47:36
 
 
To
30/10/2003 12:13:40
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00844577
Message ID:
00844608
Views:
37
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"
Previous
Reply
Map
View

Click here to load this message in the networking platform