append from

[dtussman]

Anyone else notice that when you APPEND FROM a file the resulting file includes deleted records from the source file and the deleted records are now undeleted, even if you Set Deleted on? That is something you need to beware of

[Euclides]

Hi dtussman.
Clipper does the same long time ago.
The funny thing is: "APPEND FROM <file> FOR !deleted()" does not work either. (of course)
Regards, Euclides.

[dtussman]

I guess that's true backward compatability then!

[James Bott]

David,

From the book CA Clipper 5.3:

Deleted records: If DELETED is OFF, deleted records in
<xcFile> are APPENDed to the current database file and retain their
deleted status. If DELETED is ON, however, none of the deleted
<xcFile> records are APPENDed.

I always do a SET DELETED ON at the beginning of all my programs. If for some reason I need to see deleted records (very rare), then I turn it off, then back on at the end of the routine (think encapsulation).

James