Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
REPLACE doesn't ....a feature????
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00498797
Message ID:
00498817
Vues:
15
>>I got nailed by this obscure feature and I feel very lucky to have discovered
>>the fine print at the bottom of the REPLACE help before spending hours trying
>>to figure out why the replace wasn't happening.
>
>
>Think of it this way. You're past the last record in a table in the current
>area (IE, you're at EOF()). Now, when you try to do a REPLACE in this table,
>what are you replacing? That should give you your answer...

Or more to the point,
USE tableA IN 0
USE tableB IN 0
USE tableC IN 0

SELECT tableA
GO BOTTOM 
STEP

REPLACE tableA.field1 WITH "fred", ;
        tableB.field2 WITH "barney", ;
        tableC.field3 WITH "wilma"
What happens?
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform