Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copying contents of field from a table based on another
Message
From
13/02/2004 10:43:34
Michael Vassallo
Efi, Inc.
Pittsburgh, Pennsylvania, United States
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Copying contents of field from a table based on another
Miscellaneous
Thread ID:
00877106
Message ID:
00877123
Views:
11
You can scan through the correct table and set the path in the updating table where the key fields match
SELECT table1
SCAN
    SELECT table2
    REPLACE PATH WITH table1.path WHERE KEY = table1.key ALL
ENDSCAN
Previous
Reply
Map
View

Click here to load this message in the networking platform