>>Nadya,
>>
>>The FOR clause on APPEND FROM acts on the source of the append not the target.
>
>Exactly what I was thinking. So, where VFP allows you to perform some checks on the data, it won't be able to evaluate stuff like Recno(). Now I think of it, this will be the same as FOR NOT DELETED() won't work (never thought of it this way ;).
>Knowing this, it can be solved by having a nRecno field in the source table (obviously equal to Recno()) and you will be able to test for that (with WHILE if possible) ...
Foxpro can evaluate Recno(), Reccount() and alike in APPEND FROM. See my message to Jim.
--sb--