VFP 9 SQL and Industry Standards (by John Koziol)

Perhaps overshadowed by massive enhancements to other product areas are the changes made to the Visual FoxPro data engine. Major changes have been made to that area to eliminate or greatly ameliorate product limitations; eg, subquery limitations. Also, some behavior has been tweaked to ensure compliance with SQL Server or ANSI SQL standards. Big changes that'll benefit our pals, but the magnitude of the changes kinda take our breath away; the potential for ripple (see earlier post here) is large.

Allow me an aside - two folks get a lot of credit for pushing this:  Aleksey Tsingauz and David Anderson. Aleksey - a Fox Team developer - has spent a lot of time studying and implementing standards, such as Joe Celko's SQL for Smarties, and ensuring that the VFP engine lived up to those standards. David, a contract tester well-known to early Fox aficianados, has been testing the heck out of the changes and has implemented some great TPC benchmark tests.

However, as I've said before, we're a handful of earnest guys and you're a gang of thousands. I'd love to see those of you with your hands on the beta to pound on the thing with heavy SQL queries. This would really help out. And, indirectly, help you out.

Ken has asked for a call to action in his latest column.  Here's my call to action.  Thanks.