Hi,
Why not use a SCAN..ENDSCAN with no order set like this:
USE MyTable EXCL
SET ORDER TO
SCAN
IF Flag = 'AAA'
Replace Flag with 'ZZZ'
ENDIF
ENDSCAN
HTH,
Arriyel
>MyTable has 100 records. There are multiple records where "AAA" is the value in the Flag field. When the value of Flag is changed to "ZZZ" in the code the loop is terminated though there are more "AAA" records to be changed. I understand this as the record pointer is moving with the changed record within the order, but how can I program around it without doing "Replace For" against the table? Thanks!
>
>
>Use MyTable excl
>Index on Flag Tag Flag
>If Seek('AAA')
> Do While Flag = 'AAA' and !EOF()
> Replace Flag with 'ZZZ'
> Skip
> Enddo
>Endif
>
>
>Regards, Renoir
Speak using soft and sweet words in case you have to eat them later.