>You can perform a REPLACE on a table that isn't the currently selected table without using the IN clause, if you prefix the columns with the appropriate alias:

While you can do that, it's not a good idea and it runs the risk of not behaving as you expect. You're at risk if the current work area is at end of file, and you may not see what you think you will if any of the work areas are at EOF.

In my view, no REPLACE should address more than one table, and every REPLACE should include the IN clause. For that matter, every Xbase command that accepts it should include the IN clause.

Tamar