>>>With NOFILTER (and deleted still off), yes, all records are returned and the deleted flag is wiped regardless of any other setting.
>>>
>>>What I haven't tested yet is whether or not it speeds up the query. That's my next step.
>>>
>>I have skipped most of the thread so pls forgive if I am totally off target:
>>Since you seem to use SQL-Select, would not something like
>>Select *, deleted() as lWasdeletd from ...
>>fill your need the keep the info on the deleted() status of the base table for your next steps ?
>>
>>regards
>>
>>thomas
>
>Interesting idea. Hadn't thought of that, I must admit. Anything is worth trying
>
>Thanks
Not to be pesky, but I did suggest it in my first message to you <g> I called the field lDeleted, though <g>
If it's not broken, fix it until it is.
My Blog