|
|
|
|
|
|
|
|
|
|
- Overview
- Form window
- General case
- Form
- Form with linked form
- Form with browse
- Plug with linked table - single link
- Linked table sheet - complex linkage
- Table window
- General case
- Table
- Table with detailed form
- Table with linked table
- Relation table
- Vision window
WINDEV: Windows created via the "window" RAD
The wizard for window creation proposes several types of windows associated with HFSQL data files. To start this wizard: - Click
 in the quick access buttons. - When the new element window appears, click "Window" then "Window".
- In the wizard window, click the "RAD" tab to see the different types of windows.
The different types of windows depend on the selected RAD pattern. Indeed, each type of pattern proposes a selection of reusable types of windows. The most common window types are: - Form window: simple, with path, with linked table simple or complex connection), with linked sheet.
- Table window: simple, with detailed form, with linked table, of relation.
- Vision window.
Note: The characteristics of the windows may be different depending on the selected pattern. General case A form window displays the values of a record in a form, on the basis of one value per control. The records can be accessed one by one. The form can: - Allow (or not) the move to the previous and next records.
- Allow (or not) the creation, modification and deletion of records.
The different types of Fiche windows are as follows: Form This type of window is used to view and modify a record. This type of window does not allow you to: - Browse the different records.
- Create or delete a record.
A "Simple form" window is made of: - Buttons used to validate or cancel the input.
- Fields linked to data file fields.
In most cases, the "Simple form" window is accessible from a "Simple table" window to view or modify the current record. Form with linked form This type of window displays the contents of data files linked by a simple connection (1 - N). The values of the record in the main data file and the records linked to the current record (in the main data file) are displayed in two sheets. This type of window is made of: - A form (at the top) which displays the values of the current record in the main data file.
- A form (at the bottom) which displays the values of a record linked to the current record in the main data file.
- Buttons used to:
- browse the records displayed in the two forms,
- create a new record in the main data file and in the linked data file,
- delete the current record from the main data file and the linked data file,
- close the window.
The "Record with linked table" window is recommended when only one record is linked to the current record in the main data file. Form with browse This type of window is used to: - Modify the record displayed.
- Create a record.
- Delete a record.
- Print the current record.
- Move to another record (next or previous one).
A "Form with browse" window is made of: - Fields linked to data file fields.
- Four navigation buttons.
- Buttons used to:
- create a new record,
- delete the current record,
- print the current record,
- close the window.
Compared to a "Card", a "Card with route" offers: - an easy way to move from a form to another one,
- the ability to create several records in a row.
Tip For data files with many records, it is preferable to select the records in a Table control and modify or view the selected record in a "File" window. Selection from a Table control is much faster. Plug with linked table - single link This type of window displays the contents of data files linked by a simple connection (1 - N). The record values of the main data file are displayed in a sheet. Records linked to the current record (in the main data file) are displayed in a Table control. This type of window is made of: - A form (at the top) which displays the values of the current record in the main data file.
- A Table control (at the bottom) which displays records related to the current record in the main data file.
- Buttons used to:
- browse the records displayed in the file and in the Table control,
- create a new record in the main data file,
- delete the current record from the main data file,
- close the window,
- add a line in the Table control,
- edit a line in the Table control,
- delete a line in the Table control.
Remarks: - If the data file displayed in the table is a relationship data file, the window includes the necessary buttons to access the other relationship data file.
- If this type of window is selected for a data file that has no linked data file (with a 1-N link), WINDEV will indicate this.
Linked table sheet - complex linkage This type of window is used to view at the same time: - the contents of a data file in a Table control,
- the contents of a data file in a file card.
The records displayed in the Table control and those stored in the master record are linked by a complex relationship (N - N). The "Form with relation table" window includes: - A form (at the top) displaying the records in the main data file.
- A Table control (at the bottom) which displays records related to the current record in the main data file.
- Buttons used to:
- browse the records displayed in the file and in the Table control,
- create a new record in the main data file,
- delete the current record from the main data file,
- close the window,
- add a line in the Table control,
- edit a line in the Table control,
- delete a line in the Table control.
The "Form with relation table" window is recommended when: - the details of the data file should be displayed immediately.
- the data file contains image or multiline fields to be displayed.
General case A table window displays the records in a table (rows and columns). Several data file records can be displayed in the window. The items of the same record are displayed by rows. Note: This type of window is automatically generated during a Drag and Drop (drag/move) of a data file name or a query name present in the "Project" or "Analysis" pane to the workspace. The different types of Table windows are as follows: Table This type of window is used to: - View records in a table control.
- Create a record.
- Delete a record.
- Modify a record.
- Printing the data file.
A "Table" window consists of: - A Table control that displays the records in the linked data file.
- Buttons used to:
- browse the records displayed in the Table control,
- create a new record,
- modify a record,
- delete a record,
- print the records,
- close the window.
This type of window is recommended in all cases of data file management except: - If the details of the record must be displayed immediately: use the table window with detailed form instead.
- If some items must be displayed in multiline controls: use a window with table and detailed form instead.
- If the data file contains images to be displayed immediately: prefer the window with table and detail sheet.
- If the data file has a lot of fields to display: prefer the window with table and detail sheet.
- If linked items must be displayed: use a form window with linked table instead.
Table with detailed form This type of window displays the contents of a data file in a Table control and in a file card in the same window. This window allows you to select a record in the Table control and view the details of the selected record in a file. The "Table with detailed form" window includes: - A Table control (at the top) which displays the records in the data file.
- A form (in the lower section) displaying the values of the line selected in the Table control
- Several buttons used to:
- browse the records displayed in the Table control,
- create a new record,
- modify the current record,
- delete the current record,
- close the window.
The "Table with detailed form" window is recommended when: - The data file contains image or multi-line fields for display.
- The details of the record must be immediately visible.
- The data file has many fields to display.
Table with linked table This type of window displays the contents of data files linked by a simple or complex connection in the same window. Table fields are cascaded: the second Table control displays records related to the line selected in the first Table control. The "Table with linked table" window includes: - A Table control (at the top) which displays the records in the master data file.
- A Table control (at the bottom) which displays the records in the linked data file, corresponding to the current record selected in the first Table control.
- Buttons used to:
- browse records displayed in Table control fields,
- create a new record in the main data file,
- modify the current record in the main data file,
- delete the current record from the main data file,
- close the window,
- add a line to the linked data file,
- modify a line in the linked data file,
- delete a line in the linked data file.
Relation table This type of window lets you view the records in a data file. This type of window does not allow the creation, modification or deletion of records in the data file. The "Relation table" window includes: - A Table control that displays records.
- Buttons used to:
- browse the records,
- close the window.
Vision window Vision windows are used to select a record in a table. For example, when entering an order, Vision windows can be opened to select the customer and the product. Vision windows are called up by the button labeled [...] in windows linked to a data file.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|