In foxpro this unique ability to:
- hide deleted records (so users cannot see them, records are ignored in reports etc),
- review them if needed (set dele off),
- recall them if needed (recall command), etc.
is very useful. You can review the history, fix if the record was deleted unintentionally, etc.
>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