A new Visual FoxPro book has announced, authored by Tamar E. Granor and Della Martin's latest titled Taming Visual FoxPro SQL: Real World Data Solutions in VFP. It is available for electronic download (2.3MB) purchase (PDF format only) by Hentzenwerke Publishing, 152 pages.
Visual FoxPro offers two ways to manipulate data, the traditional Xbase record orientation and SQL's set orientation. SQL commands let you specify "what" without having to know "how," letting you focus on the results you need. While VFP has included SQL commands for more than a decade, their capabilities have expanded considerably in recent versions. This book puts VFP's SQL commands under the microscope, examining each clause to explain how and why to use it. It covers both data definition commands, like CREATE TABLE and ALTER TABLE, and data manipulation commands, such as UPDATE and SELECT. Dozens of examples demonstrate solutions to both common and less common problems.