The APPEND FROM ... FOR doesn`t work as expected. The only version that has it correctly is FoxPro for Unix.

V

>In the help (both "F1" and book) for APPEND FROM, it states in the example that APPEND FROM customer FOR country = 'Finland' would mean that FP supposed to look in the customer.country and append ONLY 'Finland' from customer into the backup, is that correct? How come it does not really work that way in the real world? Are there another command or better way of doing this? INSERT - SQL will not work, since I am NOT using any form (SCATTER/GATHER). Any idea or what to do about the old APPEND FROM command?