That's been my experience, as well. I know someone has suggested it in this thread already but to reiterate a foolproof method is to:
SELECT specified_fields_or_expressions_with_casting_and_appropriate_field_names_for_destination_file;
FROM tablefrom ;
WHERE for_expression ;
INTO CURSOR tempcurs
SELECT tableto
APPEND FROM DBF('tempcurs')

>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?