PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • Overview
  • Form window
  • General case
  • Simple form
  • Form with browse
  • Form with linked table
  • Form with relation table
  • Form with linked form
  • Table window
  • General case
  • Simple table
  • Table with detailed form
  • Table with linked table
  • Relation table
  • Vision Plus window
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Overview
The wizard for window creation proposes several types of windows associated with HyperFileSQL data files.
To start this wizard:
  • Click among the quick access buttons.
  • The element creation 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 types of window are:
  • Form window: simple, with browse, with linked table, with relation table, with linked form
  • Table window: simple, with detailed form, with linked table, of relation
  • Vision Plus window.
The following paragraphs present for each type of window:
  • the operating mode of the window,
  • the different controls found in the window,
  • a preview of the window,
  • tips.
Remark: The characteristics of the windows may slightly differ according to the selected pattern.
Form window

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.

Simple 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.
  • Controls linked to the 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 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 record).
A "Form with browse" window is made of:
  • Controls linked to the 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 "Simple form" window, a "Form with browse" window proposes:
  • an easy way to move from a form to another one,
  • the ability to create several records in a row.
Tip: For the files that contain a lot of records, we advise you to select the records in a table and to modify or view the selected record in a "Simple form" window. Indeed, the selection is faster in a table.

Form with linked table

This type of window is used to view in the same window the content of files linked by a simple link (1 - N).
The values of the record found in the main file are displayed in a form. The records linked to the current record (in the main file) are displayed in a table.
This type of window is made of:
  • A form (in the top section) used to display the values of the current record found in the base file (main file).
  • A table (in the bottom section) used to display the records linked to the current record in the main file.
  • Buttons used to:
    • browse through the records displayed in the form and in the table,
    • create a new record in the main file,
    • delete the current record from the main file,
    • close the window,
    • add a row into the table,
    • modify a row in the table,
    • delete a row from the table.
Remarks:
  • If the file displayed in the table is a relation file, the window contains the buttons required to access the other relation file.
  • If this type of window is selected for a file with no linked file (1-N link), WINDEV signals it.

Form with relation table

This type of window is used to view at the same time:
  • the content of a file in a table,
  • the content of a file in a form.
The records displayed in the table and the ones saved in the form are linked by a complex link (N - N).
The "Form with relation table" window includes:
  • A form (in the top section) used to display the records found in the base file (main file).
  • A table (in the bottom section) used to display the records linked to the current record in the main file.
  • Buttons used to:
    • browse through the records displayed in the form and in the table,
    • create a new record in the main file,
    • delete the current record from the main file,
    • close the window,
    • add a row into the table,
    • modify a row in the table,
    • delete a row from the table.
The "Form with relation table" window is recommended when:
  • the details of the file must be displayed immediately.
  • the file contains image items or multiline items to display.

Form with linked form

This type of window is used to view in the same window the content of files linked by a simple link (1 - N).
The values of the record found in the main file and the records linked to the current record (in the main file) are viewed in two forms.
This type of window is made of:
  • A form (in the top section) used to display the values of the current record found in the base file (main file).
  • A form (in the bottom section) used to display the values of a record linked to the current record in the main file.
  • Buttons used to:
    • browse the records displayed in the two forms,
    • create a new record in the main file and in the linked file,
    • delete the current record from the main file and from the linked file,
    • close the window.
The "Form with linked table" window is recommended when a single record is linked to the current record in the main file.
Table window

General case

A table window displays the records in a table (rows and columns). Several file records can be displayed in the window.
The items of the same record are displayed in row.
Remark: This type of window is automatically generated when a file name or a query name found in the "Project" or "Analysis" pane is dragged and dropped into the workspace.

Simple table

This type of window is used to:
  • View the records in a table.
  • Create a record.
  • Delete a record.
  • Modify a record.
  • Print the file.
A "Simple table" window is made of:
  • A table used to display the records found in the linked file.
  • Buttons used to:
    • browse the records displayed in the table,
    • create a new record,
    • modify a record,
    • delete a record,
    • print the records,
    • close the window.
This type of window is recommended in all the cases of file management except:
  • If the details of the record must be displayed immediately: prefer the window with table and detailed form.
  • If some items must be displayed in multiline controls: prefer the window with table and detailed form.
  • If the file contains images that must be displayed immediately: prefer the window with table and detailed form.
  • If the file contains a lot of items to display: prefer the window with table and detailed form.
  • If linked items must be displayed: prefer the form window with linked table.

Table with detailed form

This type of window is used to view in the same window the content of a file in a table and in a form. This window is used to select a record in the table and to view the details of the selected record in a form.
The "Table with detailed form" window includes:
  • A table (in the top section) used to display the file records.
  • A form (in the bottom section) used to display the values of the row selected in the table
  • Several buttons used to:
    • browse the records displayed in the table,
    • 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 file contains image items or multi-line items to display.
  • The details of the record must be immediately visible.
  • The file contains a lot of items to display.

Table with linked table

This type of window is used to display in the same window the content of files linked by a simple link or by a complex link. The tables are cascading tables: the second table is used to display the records linked to the row selected in the first table.
The "Table with linked table" window includes:
  • A table (in the top section) used to display the records found in the base file.
  • A table (in the bottom section) used to display the records found in the linked file, corresponding to the current record selected in the first table.
  • Buttons used to:
    • browse the records displayed in the tables,
    • create a new record in the main file,
    • modify the current record in the main file,
    • delete the current record from the main file,
    • close the window,
    • add a row into the linked file,
    • modify a row in the linked file,
    • delete a row from the linked file.

Relation table

This type of window is used to view the file records.
This type of window does not allow you to create, modify or delete the file records.
The "Relation table" window includes:
  • A table used to display the records.
  • Buttons used to:
    • browse the records,
    • close the window.

Vision Plus window

The Vision Plus windows is used to select a record in a table. For example, when entering an order, Vision Plus windows can be opened to select the customer and the product.
The Vision Plus windows are called by the button whose caption is [...] in the windows linked to a file.
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment