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