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.