In this chapter:
- Creating basic queries
- Adding criteria to queries
- Adding calculations to queries
- Adding parameters to queries
- Totals and queries
- TOP value queries
- Unique values in queries
In this chapter, we will look at how to create queries in a web app. These queries can then be used either with views to display information or with data macros to process information. If you are familiar with this subject, you will notice that in the contents there are no topics on creating queries to modify data. Queries that modify data are not supported in a web app; instead, you use data macros to perform equivalent operations.
In Chapter 5, “Displaying data in views,” I demonstrated creating a simple query for creating a jump list to summarize product data in our application. In this chapter, I provide a more detailed explanation of how queries are created and how they can then be used in your application. As you did in Chapter 5, you’ll use some simple user-interface macros to link your queries to views. In Chapter 7, “Programming a web app by using macros,” I will provide a more detailed discussion of macro design.
If you want to follow along with the design steps in this chapter, continue to use the NorthwindData web app used in Chapter 5.
Read the complete chapter here: https://www.microsoftpressstore.com/articles/article.aspx?p=2302366.