Views and Queries Solution Samples

JavaScript Editor js editor     Web development 



Main Page

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.


JavaScript Editor js editor     Web development