SET DELETED ON, hey? I have to ask myself how in the world it is that I didn't know about it! It certainly would have saved me a lot of time, not only here, but other places as well.
Thanks!
Jim
>To solve the task you may use:
>
>set dele on && deleted records will be hidden, not used
>append from cMyCursor
>
>However 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.
>
>
>
>>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
Jim Nelson
Newbury Park, CA