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.