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

Click here to load this message in the networking platform