>Dear Jim
>
>Thanks for replying I'm your student from Appdev, According to your lessons the following should work...
>
>
>SELECT *,SPACE(8) as nafseq2 from znaf INTO TABLE datax\znaf2
>
>seq=8950
>SCAN
>seq=seq+1
>replace znaf2.nafseq2 WITH ALLTRIM(znaf2.nafseq) IN znaf2
>replace znaf2.nafseq WITH STR(seq,8) IN znaf2
>ENDSCAN
Simon,
Might it be that there were another table/cursor opened with alias znaf2 ? If that's the case no replacement would occur in this table biut other one where current record is repeatedly updated with replaces.
Also to be sure check if that's a buffering problem.
Cetin