Inquiries
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
Refer to documentation Implementation
Screen management
Header
Code (field COD) |
This code identifies the inquiry. |
Description (field DES) |
This text is picked up in the tile of the tab for the principal inquiry window. |
Tab Screens
The first tab is used to identify the windows used by the inquiry as well as to define the general characteristics.
Characteristics
Module (field MODULE) |
Select a module for the setup. Use this field to specify if the screen has to be created in the folder database. This is the case when the module linked to the screen is active on the folder. |
Activity code (field CODACT) |
An activity code is used to:
If the activity code is disabled:
|
Scripts
Standard script (field PRGSTD) |
The following must be developed in this process :
This process must contain the label $ACTION. |
Specific script (field PRGSPE) |
Reserved for the distributor. Identical behaviour to the standard process. |
Data
Main window (field WND1) |
The main window in the inquiry is made up of a header screen and a tab with a grid having NBLIG as its bottom of page field. It is however possible to add additional tabs on the condition that they are filled by the process. Rules on construction. The grid screen is also used as a reference screen in the management of enquiry screens. |
Criteria window (field WND0) |
This window is optional. It groups the selection criteria, the sort criteria, the memo code, the code for a screen can be parameterized. It must be without a header and have a single tab. Rules on construction. |
Header screen (field SCRNAM1) |
field SCRABB1 |
Grid screen (field SCRNAM2) |
field SCRABB2 |
Criteria screen (field SCRNAM0) |
field SCRABB0 |
Block number 4
Default screen code (field SCRCOD) |
This zone is optional.
|
Header fields (field FLD1) |
This grid is used to make a correspondence between the header screen criteria fields and those of the criteria screen and to identify the display criteria whether they are in the header screen or in the criteria window. During enquiry, the modification of the display criteria causes the redisplay of the current enquiry page, whilst the modification of the other criteria causes a new search from the first page. |
Criteria fields (field FLD0) |
Display criterion (field DSYCRI) |
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.
Grid
Tables to open (field FILOPN) |
Indicate the tables to open at the start of the inquiry. They will be opened with the abbreviation defined in the table dictionary. |
Tab Miscellaneous
Search key
Linked object (field OBJET) |
Indicate the associated object, when wanting to be use it and to update the "last read" by the inquiry. |
Table (field FILNAM) |
used to manage the radio buttons, if they are parameterized for this inquiry. If an object has been specified, the table managed by this object will be loaded here. Also indicated here is what abbreviation the table uses in the inquiry management. By default, the abbreviation in the table dictionary is proposed. This field is not used to filter the records in the inquiry. |
field FILABB |
Key (field FILKEY) |
Indicate the key for the table, for the radio buttons and the management of the last read. |
Site field (field ZSITE) |
Access code field (field ZACC) |
Conditions (field FILCND) |
This zone is optional. It makes it possible to indicate a selection criterion for a table in a way that ignores certain inappropriate records by using the radio buttons or in the management of the last read. |
Radio buttons (field MAGNETO) |
Used to activate the radio buttons : First, Previous, Next and Last at the top of the principal inquiry window. |
Key component (field CPNKEY) |
Header fields (field CPNSCR) |
Indicate the correspondence between the components of the key and the fields in the inquiry header screen. |
Block number 3