Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
UPDATE vs REPLACE
Message
From
26/07/2005 15:47:51
 
 
To
26/07/2005 15:15:50
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01036002
Message ID:
01036010
Views:
29
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform