Joao,

Your code wouldn't work anyway. You were doing a replace on the first record as many times as there were records. Instead use the scan/endscan loop for this;

SELECT TheView
lnCounter = 1
SCAN
   REPLACE ...
   lnCoutner = lnCoutner + 1
ENDSCAN

You have no need to get the record count here because scan will loop through all of the records.