Ken;

You should alter the ODBC setup to not display deleted records. There is a checkbox option on the Options tab when you create your ODBC connection.

If you are creating a connection string, add DELETED=NO to your string (or Deleted=Yes) I'm not sure which one turns off deleted records!



>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