|
|
|
|
|
- Overview
- Form window
- General case
- Form
- Form with linked form
- Form with navigation
- Form with bound table - simple relationship
- Form with bound table - complex relationship
- Table window
- General case
- Table
- Table with details form
- Table with bound table
- Relationship table
- View window
WINDEV: Windows created via the RAD model
The window creation wizard offers many types of windows associated with HFSQL data files. To open this wizard: - Click
in the quick access buttons. - In the window that 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. Each pattern type offers a selection of reusable window types. The most common window types are: - Form window: simple, with navigation, with table with simple or complex relationship, with bound form.
- Table window: simple, with detailed form, with linked table, relationship table.
- View 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. 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 Forms windows are: Form This type of window is used to view and modify a record. This type of window does not allow you to: - Navigate through records.
- Create or delete a record.
A "Simple form" window consists of: - Buttons to confirm or clear input.
- Controls bound to the data file items.
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 shows the contents of data files in a simple relationship (1 - N). The values of the record in the main data file and the records related to the current record (in the main data file) are displayed in two forms. This type of window consists of: - A form (at the top) that shows the values of the current record in the main data file.
- A form (at the bottom) that shows the values of a record related 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 related data file,
- delete the current record from the main data file and from the related data file,
- close the window.
The "Form with bound table" window is recommended when only one record is linked to the current record in the main data file. Form with navigation 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 record).
A "Form with navigation" window consists of: - Controls bound to the data file items.
- Four navigation buttons.
- Buttons used to:
- create a new record,
- delete the current record,
- print the current record,
- close the window.
Compared to a "Form", a "Form with navigation" features: - 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 a large number of records, it is preferable to select the records in a Table control and modify or view the selected record in a "Form" window. Selection is faster in a Table control. Form with bound table - simple relationship This type of window shows the contents of data files in a simple relationship (1 - N). The values of the record in the main data file are displayed in a form. Records related to the current record (in the main data file) are displayed in a Table control. This type of window consists of: - A form (at the top) that shows the values of the current record in the main data file.
- A Table control (at the bottom) that shows records related to the current record in the main data file.
- Buttons used to:
- browse the records displayed in the form 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 row to the Table control,
- edit a row in the Table control,
- delete a row from the Table control.
Remarks: - If the data file displayed in the table has a related data file, the window will include the buttons required to access that data file.
- WINDEV will show a notification if this type of window is selected for a data file that has no related data file (with a 1-N relationship).
Form with bound table - complex relationship This type of window displays both: - the contents of a data file in a Table control,
- the contents of a data file in a form.
The records displayed in the Table control and those stored in the form are linked by a complex relationship (N - N). The "Form with relation table" window includes: - A form (at the top) that shows the records from the main data file.
- A Table control (at the bottom) that shows records related to the current record in the main data file.
- Buttons used to:
- browse the records displayed in the form 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 row to the Table control,
- edit a row in the Table control,
- delete a row from the Table control.
The "Form with relation table" window is recommended when: - you need to see the details of the data immediately.
- the data file contains image or multiline items 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 a single record are laid out in rows. Note: This type of window is automatically generated when a file name or a query name is dragged from the "Project" or "Analysis" pane and dropped onto the workspace. The different types of Table windows are: Table This type of window is used to: - View records in a Table control.
- Create a record.
- Delete a record.
- Modify a record.
- Print a data file.
A "Table" window consists of: - A Table control that shows the records in the bound 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 for handling data files, except: - If the details of the record must be displayed immediately. In this case, use a table window with a details form.
- If some items must be displayed in multiline controls. In this case, use a window with a table and a details form.
- If the data file contains images to be displayed immediately. In this case, use a window with a table and a details form.
- If the data file has a large number of items to be displayed. In this case, use a window with a table and a details form.
- If some bound items must be displayed. In this case, use a form window with a bound table.
Table with details form This type of window shows the contents of a data file both in a Table control and in a form. This window lets you select a record in the Table control and view the details of the selected record in a form. The "Table with detailed form" window includes: - A Table control (at the top) that shows the records from the data file.
- A form (at the bottom) that shows the values of the row 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 multiline items to be displayed.
- The details of the record must be immediately visible.
- The data file has a large number of items to be displayed.
Table with bound table This type of window shows the contents of data files in a simple or complex relationship. Table controls are cascaded. This means the second Table control can show records related to the row selected in the first Table control. The "Table with bound table" window includes: - A Table control (at the top) that displays the records of the main data file.
- A Table control (at the bottom) that displays the records of the related data file, corresponding to the record currently selected in the first Table control.
- Buttons used to:
- browse the records displayed in Table controls,
- 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 record to the linked data file,
- edit a record in the bound data file,
- delete a record from the bound data file.
Relationship table This type of window shows the records of a data file. This type of window does not allow creating, editing or deleting records from the data file. The "Relationship table" window includes: - A Table control that shows records.
- Buttons used to:
- browse the records,
- close the window.
View window View windows allow you to select a record from a table. For example, View windows can be used to select a customer and a product when entering the details of an order. View windows are opened by the [...] button in data-bound windows.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|