Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: surinder singh
  Where is surinder singh?
 mumbai
 India
 surinder singh
 To: shiva kumar
  Where is shiva kumar?
 Hyderabad
 India
 shiva kumar
 Tags
Subject: RE: copy rec frm one table to another
Thread ID: 189321 Message ID: 189322 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: General VFP Topics
Date: Thursday, August 14, 2008 12:04:59 PM         
   


> how to copy records form one table to another table
> ex: table1 to table2
> table1 recs=1 2 2 3 3 4 5 6 7 8 8 8
> ans should copy to table2 1 2 3 4 5 6 7 8 (unique recs should be copied)
>
>
> Shiva


   select distinct * from table1 into cursor tmpCur && or into table table2
   select table2
   append from dbf("tmpCur")

-----------------------------------------------------------------------------------------------
Regards
Surinder Singh
Email: sur200@indiatimes.com
Check my blog for details: http://weblogs.foxite.com/sur200
----------------------------------------------------------------------------------------
*If you understand what you're doing, then you're not learning anything.

ENTIRE THREAD

copy rec frm one table to another Posted by shiva kumar @ 8/14/2008 12:00:45 PM
RE: copy rec frm one table to another Posted by surinder singh @ 8/14/2008 12:04:59 PM
RE: copy rec frm one table to another Posted by Anders Altberg @ 8/14/2008 2:21:30 PM