Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replace
Message
 
 
To
24/03/2005 08:47:11
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 7
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00998811
Message ID:
00998815
Views:
16
You should try a SET RELATION. It should be faster.
select 0
use neg1 order tel
select 0
use neg
set relation to tel into neg1
replace neg.team with neg1.team for not eof('neg1')
>hi all,
>i have 2 tables, first 1 (neg1) have 30021 records, another (neg) have 2630
>i need to replace neg.team with neg1.team where neg.tel=neg1.tel
>i try via this code under, but not work
>
>
>
>
>      select 1
>      use neg1
>do whil .t. .and. !eof()
>scatter memvar
>             m.tel=tel
>             m.team=team
>     select 2
>      use neg
>       replace team WITH m.team FOR tel=m.tel
>     brow
>               select 1
>      skip
>   if eof()
>    exit
>   endif
>enddo
>CLOSE ALL
>
>thanks
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform