by Tamar E. Granor with Della Martin Edited by Anders Altberg ISBN: 1-930919-68-9 Length: 152 pages Formats Available: Ebook only Printed book format: N/A Ebook format: PDF (2.3 MB) Price ($US): 29.95 Weight: 0.0 lbs. Press date: October, 2005 Printed book availability: N/A Ebook availability: Complete & Ready for Download Source code: No source code -------------------------------------------------------------------------------- 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.