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.