>That doesn't work either. The select statement of the view is:
>

SELECT *, DELETED() as lDeleted FROM <table> etc.

>Deleted records appear in the view with .F. in the last column. When I run the same select in the command window, deleted records have .T. in the last column.

DELETED() and other XBase functions are not supported in SQL,
only with single table query some info are returned ( with some reliable risk )


In VFP9 is possible to rewrite the SQL with derivate subquery

SELECT ... FROM 
     ( SELECT DELETED() ,... FROM TABLE1 WHERE ... ) T1 
JOIN (SELECT DELETED() ... FROM TABLE2 WHERE ) T2

but this lose the ON optimization