Views and Queries Solution Samples

These Solution samples illustrate application development tasks you can perform with queries and views.

In This Section

• Interactively Build a SELECT Statement Sample
  Illustrates how to create a custom query at run time.

• Select Customers in a Specific Country Sample
  Illustrates how to use a parameterized view to display a subset of records matching a variable that is set at run time.

• Select Records from a Full Outer Join Sample
  Illustrates how to select records from two tables using a full outer join condition.

• Select Records from a Left Outer Join Sample
  Illustrates how to select records from two tables using a left outer join condition.

• Select Records from a Nested Join Sample
  Illustrates how to select records from multiple tables using nested join conditions.

• Select Records from a Right Outer Join Sample
  Illustrates how to select records from two tables using a right outer join condition.

• Select Records from an Inner Join Sample
  Illustrates how to select records from two tables using an inner join condition.

• Select Records from Both Inner and Outer Joins Sample
  Illustrates how to select records from multiple tables using a combination of inner and outer join conditions.

• Select the 10 Worst-Selling Products Sample
  Illustrates how to select the records using the TOP clause in the SQL SELECT command.

• Select the Top 10 Best-Selling Products Sample
  Illustrates how to select the records using the TOP clause in the SQL SELECT command.

Reference

• Sample Class Libraries
  Contains sample class libraries that provide encapsulated functionality you can add to your applications.

• Visual FoxPro Foundation Classes A-Z
  Describes Visual FoxPro Foundation classes you can use for rapid application development.

• Reference (Visual FoxPro)
  Includes Visual FoxPro general, programming language, user interface, and error message reference topics.

Related Sections

• Foundation Class Samples
  Contains samples that illustrate use of the Visual FoxPro Foundation classes.

• Server Samples (Visual FoxPro)
  Contains samples that illustrate Automation Servers.

• Solution Samples
  Contains samples that demonstrate particular features of Visual FoxPro and can be run independently.

• Walkthroughs
  Provides step-by-step instructions for common scenarios, making them a good place to begin learning about the various features of Visual FoxPro.