>>>Researching an update problem. Just wondering if RECALL is the only way that a deleted record can become undeleted?
>>>
>>>Thanks
>>>
>>>Brenda
>>
>>Brenda
>>
>>RECALL is the only way to programmaticlly change the delete marker on a record in place. Now to explain the qualifiers in that sentence, 'programmatically' because a user may toggle the delete marker in either an edit or browse window or may use the recall dialog box or memu option, 'in place' because if COPY TO or SORT ON is used with SET DELETED OFF then the deleted records are copied but the delete marker is not. You may wonder why COPY TO is an issue, many times (especially in older code) in order to and gain some performance you will find tables reordered to match their primary index. To rearrange the table it was indexed and copied or sorted to a temp file, the original was then either zaped and appended from the temp file or erased and the temp file renamed to the original. This may seem like a lot of trouble, but when you learn to database on a 8086 with duel floppy drives you learn to take every advantage you can get.
>>
>>Good Luck
>>Donny
>
>Just to add my historical $0.02...
>The PACK command in dBASE II and III was a little iffy. Disk space was also an issue back in the Dark Ages (before Windows, when there was no light < G> ). It was more reliable to copy a file, leaving behind the deleted records. It was also a great help in speeding things up (back in the days of 7MHz) to have the data sorted by primary key order...

There are many of us who feel that Windows created a need for artificial light by blocking out the Sun...and Data General and MIPS, too...


>
>To answer your original question, RECALL is the only programmatic way to undelete a record. Personally, I don't like to give the end user access to delete/recall via a browse window. But there again, I don't like giving the end user much of anything that I can't control. I prefer to have them do a 2-stage delete: select the record, then click on a delete button. Sometimes I make them confirm deletion as well, depends on the user.
>
>HTH
>Jen