>Have you seen one like this before? It's simple but maddening.
>
>The first line does not replace. The second one does.
> REPL sp_f17euc.COBOR1AGE with str(insapp.COBOR1AGE)
> REPL sp_f17euc.COBORR2 with insapp.COBORR2
>The only difference is the str() on the numeric field, which should not matter.
>
>I added output windows to confirm and flushed the buffer to ensure a write to disk as follows without success.
> wait wind sp_f17euc.COBOR1AGE +' / '+str(insapp.COBOR1AGE)
> REPL sp_f17euc.COBOR1AGE with str(insapp.COBOR1AGE)
> flus
> wait wind sp_f17euc.COBOR1AGE +' / '+str(insapp.COBOR1AGE)
> REPL sp_f17euc.COBORR2 with insapp.COBORR2
>
>Both files are open and some fields do update. I cannot use scatter/gather or tableupdate() as the type of fields of the same name are different. I have to use replace...with. Replace...with always works, doesn't it?
>
>This is not a case of other users locking the records or of memory problems. Any help? Thanks.
There is one situation when plain REPLACE fails (w/out error messages). It happens if current work area sits on EOF() and you try to replace in another area. SO the fix is either SELECT the area first, or use IN clause of REPLACE command.
Edward Pikman
Independent Consultant