>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
Donny Sims
Life is what happens to us while were busy making other plans.
- John Lennon