Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
UPDATE vs REPLACE
Message
De
26/07/2005 15:47:51
 
 
À
26/07/2005 15:15:50
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01036002
Message ID:
01036010
Vues:
28
PMFJI,
but how can that be true for REPLACE, when you can put the clause FOR myTable.myfield = m.myvariable and put WHERE myTable.myfield = m.myvariable on the UPDATE command, which could potenially (sp?) move either of them.

TIA
Beth
>Yes, UPDATE will move the record pointer. To use REPLACE, the record pointer already has to be at the proper record. IMO, it's not a big deal.
>
>
>>Is it true that UPDATE moves the record pointer and REPLACE does not?
>>
>>
>>UPDATE MyTable SET MyTable.MyField = SomeValue
>>REPLACE MyTable.MyField WITH SomeValue IN MyTable
>>
>>
>>It seems that way to me, but my tests have been somewhat inconclusive in the data environment I have to work in right now.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform