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