An inquiry is used to extract information from one or more tables, presented in the form of a grid. The selection is made as a function of criteria that can be entered at the start of a search.

The inquiry management gives the possibility :

 to parameterize the inquiry screen,

 to present the result of an inquiry in the form of a graph,

 to have memo management, to save the selection criteria. The memo extension code is entered in the memo coding table. 

An inquiry presents itself in the form :

 a window composed of a header containing the principal selection criteria and a tab displaying the result of the selection in the form of a grid. There is however no limit to a single tab.

 a window made up of a single screen. This is a window that can be called from the "Criteria" button. It is used as its name suggests for the complete entry of the selection criteria, the record sort criteria, the entry of memos, the entry of a screen that can be parameterized for the display of the inquiry results.

 There is no left list.

The graph can be personalized and is considered as parameterization. It is entered in the screens for the inquiry parameterization.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

Header

Tab Screens

The first tab is used to identify the windows used by the inquiry as well as to define the general characteristics.

Tab Tables

In this tab, it is possible to give a list of database tables to be opened at the start of the inquiry : these tables will be opened with the dictionary abbreviation and accessible in the inquiry.

Tab Miscellaneous