In this chapter, you will learn about different mechanisms for retrieving data from the database:
selectstatements at runtime
selectstatements that are used in X++ to fetch data from the database to the application
After reading this chapter, you will know how to use these mechanisms and which one of them to use in different cases.
Queries are typically used to ask users about ranges and sorting and selecting data based on the feedback from the users. A query can consist of one or multiple data sources and can be created both as static queries in AOT or as dynamic queries using ...