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
Design a page by adding two buttons and two
input boxes, and disable the input controls.
Map the input parameters of the query to the
input controls.
Create two custom globals for page number and
page size and provide default values as shown in
the following figure.
Select each button and set the action to set
the global value using a formula as shown in the
figure (+ for next, - for previous).
Select each button and set the display condition as shown in the following figures.