John Koziol is calling on the FoxPro community to bang on the new SQL features in the Visual FoxPro 9 beta.
I posted a few of those changes yesterday and there are more to come.
If you've got a lot of tables, try it out.
John - one thing that was commented by Frank Camp was that with the removal of all these limitations, the amount of code that can be on a single line is going to be an issue. The max length is still 8192 characters and if you have to specify the individual fields, it's going to be an issue. I don't usually post ERs on the blog but the one thing I would hate to see in code is:
lc = "SELECT " + lcFlds + " from " +lcFrom + "....."
He also singled out Aleksey Tsingauz and David Anderson for their efforts on this.
It's great to learn more about who's making up the "handful of earnest" guys - instead of just the usual suspects we always hear about. Keep it up John!
VFP 9 SQL and Industry Standards (by John Koziol)