VFP7 View picking up deleted records?

[tonedef]

I have a local view that is selecting information from a number of tables. The problem is the view is picking up records from the tables that are marked for deletion even though my application has set deleted on. Is there a way to prevent the view from doing this? It is causing a report to print inaccurate values since it is adding amounts that have been deleted by the user.

Thanks,

tone

 

[EzLogic]

in your Sql statement, you may add:

And !deleted()

Please let me know if this helped you

Tekno
Wireless Toyz
Ypsilanti, Michigan

 

[craigsboyd]

If you are creating an view through code then add a where clause like the following seperating each table you want to make sure doesn't return deleted records with an AND:

WHERE deleted("tblName&quot = .f.

if you are doing it from the view designer then go to the Filter tab and add expressions deleted("tblName&quot to the Field Name column and '=' for the Criteria column and .F. in the Example column for each table. Slighthaze = NULL