|Format:||Electronic Book Text, 165 pages|
|Published In: ||United States, 01 October 2005|
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.