>>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
Hey Fabio,
Who cares. Can you see a good reason to create a multitable local view (maybe there is a good reason for single table ones that I'm not aware but I suspect that there would be a single benefit of multitable version).
Cetin