Displaying the List of Results

Context

You want to execute a query online and display the list of results on the screen.

Procedure


  1. Choose a query and carry out either the Execute , Execute with Variant or Test function.

    The selection screen appears. You can enter your selection conditions here.

    Selection screens consist of two parts:

    • The upper part of the screen contains the database selections. These are determined by the underlying logical database and are automatically displayed on the screen.

    • The lower part of the screen contains program parameters that come either from defining the InfoSet or the query, or that were automatically generated by the query.

  2. Choose the Execute function.

Results

The chosen query is executed and the result is displayed in a list:

Limitations to Database Access

All selection criteria and parameters from you selection screen are checked to see if the number of database accesses should be limited. The following parameters are NOT checked:

  • all parameters automatically added to the selection screen by the query (date of currency conversion, direct interaction specifications, and so on).

  • all invisible parameters, and

  • all parameters that appear as either radio buttons or checkboxes on the selection screen.

The query is executed without further testing as soon as the system comes across a single parameter or selection criteria in any of the other fields. If this is not the case, the dialog box asking you to restrict the number of database accesses appears, much the same as the dialog box that appears during the Test function. (Exception: this does not occur if you are executing the query with variants or in the background).