Hey Bob,

It's a convoluted command...I had DELETED=NO, thinking it meant no deleted records. I changed it to = YES and it works.

Thanks much!
Ken

>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