Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replace in one cursor for match in another
Message
From
22/09/2006 08:06:00
 
 
To
22/09/2006 07:56:43
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01156327
Message ID:
01156332
Views:
18
This message has been marked as the solution to the initial question of the thread.
>What's the best (simplest <s>) way to replace a value in cursor2 with a value in cursor1 where they match on another value? I could scan and then locate and all that, but I figured there must be something cleaner.
Update cursor2 set field1=cursor1.field1 from cursor1 where cursor1.field2=cursor2.field2
Update (no pun intended): Sorry, this will work in VFP9, but not in VFP8. Another good reason to update!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform