1. Create a view in the database as SELECT * FROM table WHERE !DELETED()
2. Access the view from ADO, not the base table.
>Hey now,
>
>I need to run a SELECT statement from an ASP page using an ADO connection to a Fox (6.0) table.
>
>The problem I'm having is that I'm picking up unwanted DELETED records from the Fox table, and ADO doesn't know how to interpret the NOT DELE() syntax...it thinks it's a program, can't find it and errors out.
>
>Anybody run into / solve this issue????
>
>TIA,
>Ken
>
>***The select statement is:
>
>SELECT Customers.Domain, Customers.IP, Renewals.RenewalDate, Customers.Months, Products.Description AS Description, Renewals.ProdNum FROM Customers, Products, Renewals WHERE Customers.Person_ID = iPerson_ID AND Customers.Status='Active' AND Renewals.CustomerID = Customers.CustomerID AND Products.ProdNum = Renewals.ProdNum AND Renewals.ProdNum IN (SELECT ProdNum FROM Products WHERE HostPlan # 0) ORDER BY Renewals.RenewalDate ASC
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05