Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Replaceing a field using another table
Message
De
20/04/2000 23:13:05
 
 
À
20/04/2000 23:06:48
Ronald Suen
Epic Solutions Inc.
Edmonton, Alberta, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00362116
Message ID:
00362120
Vues:
18
Ronald,

He didn't specifically say he was replacing only for empty policy.group_code. If he wants all records updated with the current client.Group_code, your second example would work without the "AND EMPTY...." part.

>SELECT Client
>SET ORDER TO TAG SSNumber
>SCAN
> REPLACE Group_Code WITH Client.Group_Code IN Policy ;
> FOR Policy.SSNumber = Client.SSNumber AND EMPTY(Policy.Group_Code)
>ENDSCAN
David Stevenson, MCSD, 2-time VFP MVP / St. Petersburg, FL USA / david@topstrategies.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform