Visual Fox Pro 9.0 contains more functional enhancements to the data engine than any release since 3.0.
From the new and extended functionality in SQL to new data types and a binary index, this release demonstrates the power of a mature development platform for data-centric solutions.
With support for new data types and removing many limits from the SQL language, it's now easier to develop a single code base that works with the Visual Fox Pro 9 native data engine and SQL Server. Certainly the best word to describe changes to the SQL sub-language is MORE!
There are no longer hard-coded limits to the number of elements in a SQL statement.
Ken Levy is the president and founder of Mashup X, LLC based in Kirkland, WA, and is the co-host and producer of Code Cast, a developer podcast associated with CODE Magazine.
All of the projects here are governed by the Shared Source License for VFPX unless otherwise stated or noted in a project's source code/documentation.Anyone can join-in, help and propose new VFPX projects for possible inclusion in the effort.VFPX members are fans of Fox Pro and they give generously of their time, resources, and ideas to make VFPX possible.A single SQL SELECT statement can contain more tables, more JOINs, more sub-queries, more nested sub-queries, and more UNIONs than ever before.Changes to the data engine can be summarized in five major areas: Many of these changes improve the Visual Fox Pro 9 client/server story by providing stronger interoperability with SQL Server.