Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding Records Between Tables
Message
From
26/11/1998 12:06:51
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
26/11/1998 11:16:34
Thierry Yuen
Stantec Architecture Ltd.
Calgary, Alberta, Canada
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00161609
Message ID:
00161799
Views:
27
>Thanks for the info. I played around with some coding last night, and although I'm still fairly new to the FoxPro environment, I found something that managed to work relatively well. This will be suitable for now, but I think that the insert command that you have outlined to me is another option that would work equally well. I have probably gone the long route to accomplishing this data merge. Here's a copy of the code that I have used, but I can already see that I can take the insert routine and replace it with append routine. I'll probably look at making the modifications that you recommended when I get a few other things out of the way. Thanks a lot.
>
>copy next 1 to TEMPSP
>use (m_proj+"PA") alias PA
>sele PA
>append from TEMPSP
>use (m_proj+"SP") alias SP
>sele SP
>skip
>erase TEMPSP.DBF
>erase TEMPSP.FPT
>show gets

scatter memvar memo
insert into (m_proj+"PA") from memvar
use (m_proj+"SP") alias SP in 0
sele SP
skip
show gets

Cetin:)
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform