>>>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 ;).
>
>FOR ! DELETED() works when importing a DBF file; RECNO() is a problem, since the file isn't open to give it an alias to reference.
Ed,
This was solved by some SP I recall ... ?? otherwise I dreamed. Sorry then.
Peter
>
>>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) ...