Issue SET DELETE ON.
>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
--sb--