VFP 9: Major SQL SELECT Enhancements
In previous versions, you might have to do :
SELECT * from ORDHIST where <condition> into cursor x
SELECT ordid from x
Now you can put it all into a single line.
You can also use subqueries as a line item:
SELECTcustname,custno, (SELECT sum(totchgs) From frmast) as ntotal,sum(totchgs),sum(totchgs)/(SELECT sum(totchgs) From frmast)*100 as nperc From frmast GROUP BY 1,2
This query shows the customer name, the total of all invoices (in the file), the total invoices for that customer and then the percentage of total invoices that the customer held all in one query.
In earlier versions, this would be done with multiple lines but now you can do it all in one.
All of these changes are going to be a great reason to refactor your older code. One of the joys I always get is trying to reduce the size of my application. With the new SQL enhancements in Europa, it's going to be lots of fun!