Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Replace in one cursor for match in another
Message
De
22/09/2006 08:06:00
 
 
À
22/09/2006 07:56:43
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Divers
Thread ID:
01156327
Message ID:
01156332
Vues:
20
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!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform