Hi Terry,

Actually, this might be related to your problem after all. The DELETED setting is scoped to the data session so changing to a private data session would set DELETED to its default setting. Just a thought ......

Regards,

Liam




>Hi Terry,
>
>Sorry, I should have made that clear in my original post. SET DELETED ON
>
>In a single table query you can use deleted() if you don't specify an alias or work area, but in a multi-table query you have no way of knowing in what work area or with what aliases VFP is opening the tables on which to perform the query.
>
>
>Regards,
>
>Liam
>
>
>>Interesting. How would you eliminate deleted records in the source tables from showing in the final output then?
>>
>>Terry
>>>Hi Terry,
>>>
>>>A point unrelated to your question - be careful with the use of Deleted() on multi-table queries. You may get unexpected results.
>>>
>>>Regards,
>>>
>>>Liam
>>>