>>>>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.

Come on, you know I'm kidding about SET DELETED. It only was so obvious to me that I missed listing it.