>>>Accordingly how would I set this using your syntax to apply only to the LastFile. I know you had cautioned me once before to use Select 0 but that ship has sailed in this case.
>>
>>If you have MyVal columns in both NowFile and LastFile, you would need to make sure you reference the one in LastFile by adding its alias:
>>
>>REPLACE MyVal WITH IIF( LastFile.MyVal < 7, INT( LastFile.MyVal ), LastFile.MyVal ) IN LastFile
>>
>>That should work regardless of which work area is currently selected, and whether it contains an open table or not.
>
>Exception:
>
>The current work area is on EOF and for all I know on BOF. This will stop
REPLACE ... IN xxx from working.
That is not correct. REPLACE ... IN ... was invented to just circumvent the problem.
You are confusing it with the suituation where you use something like
REPLACE Alias.Field WITH xValue
If Alias is not the currently alias and the current Alias is on EOF(), the replace would not happen.
Walter,