Hi Calvin

PMFJI

>... some testing in 2.5 and sure enough if the current record is at eof() replacements are not done in referenced tables. Was this a generally know bug?

This is not a bug, it is by design and has always been this way. REPLACE is scoped to the current work area and so, when the table in the current work area is at EOF(), no record exists for replace to work on.

The fact that the replace is actually being done in a remote work area (by prefixing the field with the name of the table) did not alter the scope for the EOF() check.

The 'IN' clause tells VFP to use the referenced table for the EOF() check rather than the currently selected one, but the behavior has not changed and if the referenced table is at EOF() no replacement will occur <g>