General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only