Thanks, I use it just to be on safe side.

>>So, there is no real reason to put set deleted off then?
>
>I wouldn't say that! I'm sure there are situations where one needs to inspect/process deleted records and it surely is needed for that kind of stuff.
>I know that I've done that kind of thing many times.
>
>
>
>>
>>>The RECALL command will do its work as desired regardless of the setting of (SET) DELETED.
>>>
>>>It would be helpful if the Command Reference entry for RECALL noted this.
>>>
>>>Similarly, the Command Reference entry for SET DELETED should make mention of this, especially since its entry, under Parameters ... ON says "Specifies that commands which operate on records (including records in related tables) using a scope ignore records marked for deletion.".
>>>
>>>SET DELETED should also have a prominent notation that a SQL-Select run with (SET) DELETED OFF will cause records that fit the select criteria to be included in the result set AND they will be in 'active' status (i.e. the DELETE flag is NOT carried forward to the result set).