replace flag with 'ZZZ' for flag == 'AAA'
With only a hundred records, indexing is not needed.
>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