You cannot use Deleted() in a multi-table query. See
http://www.berezniker.com/content/pages/visual-foxpro/queries-and-functions-which-accept-alias-parameter for more info.
In general, an application should treat deleted records as none-existent. It'll be consistent with other back end databases. If you need to mark records in some way, add an additional field.
>This query does not return any results, but I know the temp cursor has deleted records that are in the real table.
>
>
> Select * from JobItems where ipkey in (Select ipkey From csrTempJobItems Where Deleted()=.T.)
>
>
>If I run the subquery by itself, I do get the desired results for the subquery, so I do not understand why it does not work in the full query shown above:
>
> Select ipkey From csrTempJobItems Where Deleted()=.T.
>
--sb--