>Hello Foxperts,
>
>Is the following code 'proper'?
>REPLACE reprints WITH reprints+1 FOR flagged="P"
>REPLACE flagged WITH "O" FOR flagged="P"
>or should I do this:
>SCAN FOR flagged="P"
> REPLACE reprints WITH reprints+1, flagged WITH "O"
>ENDSCAN
>
>Any comment and critique gratefully accepted.
Randy,
I'd go with Dragan's connecting 2 replaces in one or Hilmar's Update SQL. Neither would be affected with current order set. However you might be surprised to know if no index tag exists on replacement fields then it'd be much much faster (nothing surprising here - no index to update).
Cetin