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