I agree. It processes much faster with one REPLACE statement as opposed to individual statements.
Cathy
>I'd preffer (if using REPLACE) to write it in one-line aproach:
>
>
>
>APPEND BLANK IN INVCount
>REPLACE INVCOUNT.cLocation WITH TempLoc,;
> INVCOUNT.cUpc WITH TempUpc,;
> INVCOUNT.nCount WITH 1 ;
> IN InvCount
>
>
>
>HTH
>
>
> Append Blank In INVCOUNT
> Replace INVCOUNT.CLOCATION With TEMPLOC
> Replace INVCOUNT.CUPC With TEMPUPC
> Replace INVCOUNT.NCOUNT With 1
>
>>Christopher,
>
>>You are doing an APPEND BLANK IN, but you are not REPLACEing IN, that might bring you wrong results. I would use Fabio's approach of using INSERT instead of APPEND/REPLACE