VFP 9 SQL and Industry Standards (by John Koziol)

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 + "....."
&lc

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)
1 comment

Popular Posts