>>>Update:
>>>SET DELETED is argh. There is an other way????
>>
>>You can SET DELETED OFF to show deleted records; and this can sometimes be used to recover records that have been deleted accidentally. But I usually find it best to consider deleted records as gone (and keep SET DELETED ON).
>
>Hi Hilmar
>
>Nothing is more strange then an environment with SET DELETED OFF. SELECT SQL is a awesome then....
>
>There are very rare points where I use SET DELETED OFF and REVERT. Some strange debugs involving record delations and the like. Never in production. Thats why I ask if there is any other way the SET DELETED ON. :)
>
>Lutz

I don't really think there's an alternative. For instance, you might envision a framework that re-uses deleted records (when adding a record, first check whether there is a deleted record; if there is, re-use it). In that case, the framework will need to temporarily turn SET DELETED OFF. I believe that some frameworks actually do that. However, you will still need to hide deleted records until they are re-used.

OK, you could include the deleted marker in the filter, but the result would be the same - and it would be more complicated.