Taming Visual FoxPro's SQL (ebook only)
Real World Data Solutions For VFP

Click HERE to order online

Table of Contents
Sample Chapters
Downloads
Updates, FAQs & Errata

Click HERE to order online

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.