Not so much a question – more an observation that may help others avoid a difficult to find bug I recently encountered.

When using APPEND FROM to add a set of records from table B to the end of table A, I found I was getting an incorrect set added. I had both tables open at the same time and the FOR condition applied to table B as a BROWSE achieved the correct subset of results. However, when applying the FOR condition to the APPEND FROM a different set of results was being passed across to table A.

I discovered that the APPEND FROM will always search for table B along the default path. APPEND FROM ignored the fact that I already had the intended table B open. I had an old version of table B higher up the search path than the one currently open and this one had spurious records some of which met the FOR criteria and were being added to table A.

You can avoid this trap by specifying the full path to table B or making sure that you only have a single instance of the file in the search path (which most folk will!).

Barry