Example of Adding Relational Database Queries to a Page

About this task

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.

Procedure

  1. Design a page by adding two buttons and two input boxes, and disable the input controls.
  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 shown in the figure (+ for next, - for previous).
  5. Select each button and set the display condition as shown in the following figures.

  6. Select Save App.

Results

The final page appears as shown here: