To solve the task you may use:
set dele on && deleted records will be hidden, not used
append from cMyCursor
In your situation the below should also work:
set dele oFF
APPEND FROM cNyCursor FOR NOT DELETED() && deleted records not accepted, no matter where they are.
As of the FOR clause: it does not matter to what table the records belong. Think of it this way: the record is being validated as if it is already in the target table, but if not valid, it is rejected.
>There'w something I don't understand about the FOR phrase when used in "APPEND FROM" -- like, what it's for and how it's used. The documentation is not helpful.
>
>What I'd like to do is the following:
APPEND FROM cMyCursor FOR NOT DELETED("cMyCursor")
>
>That is, all I want to do is to append the records that are not marked as being deleted. I missing something here, hopefully somethings that simple. The documentation, for as much as I understand it, seems to say that the FOR phrase applies to the records in the table I'm appending to; what I want to do is to select records that I'm appending from.
>
>Thanks