Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replace a field in a table using a master table
Message
 
To
19/04/2000 15:00:20
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00361486
Message ID:
00361505
Views:
24
It's REPLACE ALL, but make sure you have the Policy table selected first.


>Hi,
>>I'm trying to update a field in a table using another tables field.<
>>If I were to write it out in code it would sound like this <
>
>> SELECT CLIENT, POLICY <
>> I'd set the relationship between the to fields as SSNumbers. <
>> I'd then issue <
>> replace all policy.group_code with client.group_code ;<
>> for POLICY.SSNUMBER = CLIENT.SSNUMBER <
>> IN VFP, HOW DO YOU WRITE THIS EXPRESSON, IS IT UPDATE FOR OR <
>> REPLACE ALL ? <
>> pLEASE HELP <
>> JOHN<
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform