Example of Adding Relational Database Queries to a Page

In the following example, the query has two result sets. One is the result from the stored procedure and the other is from the output parameters. It also has inputs PageNumber and PageSize. The steps that follow describe how this page was created.

1. Add two buttons and two input boxes to the page as shown in the following figure, and make the input controls disabled.
2. Map the input parameters of the query to the input controls.
3. Create two custom globals for page number and page size and provide default values as shown in the following figure.
   
4. Select each button and set the action to set the global value using a formula as show in the screenshot (+ for next, - for previous).
   
5. Select each button and set the display condition as shown in the following figures.
   
   
6. Select Save App.
   The final page displays as shown in the first figure.