|
|
|
|
|
|
|
|
- Overview
- Form page
- General case
- Simple dynamic form
- Dynamic form with browse
- Dynamic form with linked table
- Dynamic form with relation table
- Semi-dynamic form
- Table page
- General case
- Simple dynamic table
- Dynamic table with detailed form
- Dynamic table with linked table
- Semi-dynamic table
- Looper page
- General case
- Dynamic looper
- Semi-dynamic looper
- Vision Plus page
Type of pages created by RAD
The wizard for page creation proposes several types of pages associated with HyperFileSQL data files. You have the ability to create: - dynamic pages: These pages are created from the data files found on the development computer. In deployment, the data is installed (or accessible) from the Web server. The pages display the data found in the data files.
- semi-dynamic pages: These pages are created from the data files found on the development computer. Before installing the application, these pages are converted into static pages: the data found in the data files is saved in the pages. No data file is installed on the server.
The available types of pages:
| | | Dynamic pages | Semi-dynamic pages | Form page:- simple.
- with browse.
- with linked table.
- with relation table.
| Form page | Table page:- simple.
- with detailed form.
- with linked table.
| Table page | | Vision Plus page. | | | Looper page. | Looper page. |
The following paragraphs present for each type of page: - the operating mode of the page,
- the controls found in the page,
- a preview of the page,
- tips.
General case A form page 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 dynamic form This type of page is used to view and modify a record. This type of page does not allow you to: - browse the different records.
- create or delete a record.
A "Simple dynamic form" page is made of: - buttons used to validate or cancel the input.
- buttons used to print the current record
- controls linked to the file items.
In most cases, the "Simple dynamic form" page is accessible from a "Simple dynamic table" page to view or modify the current record. Dynamic form with browse This type of page 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 "Dynamic form with browse" page includes: - controls linked to the file items.
- 4 navigation buttons.
- buttons used to:
- create a new record.
- delete the current record.
- print the current record.
- close the page.
Compared to a "Simple dynamic form", a "Dynamic form with browse" 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 containing several records, we advise you to select the records in a table and to modify or view the selected record in a "Simple form" page. Indeed, the selection is faster in a table. Dynamic form with linked table This type of window is used to view the content of the files linked by a simple link (1 - N) in the same page. 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 page includes: - 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.
- a pager used to display the table record.
- buttons used to:
- create a new record in the main file.
- delete the current record from the main file.
- close the page.
- 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 page contains the buttons required to access the other relation file.
- If this type of page is selected for a file with no linked file (1-N link), it is signaled by WEBDEV.
Dynamic form with relation table This type of page is used to view at the same time: - the content of a file in a table and
- 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" page 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.
- a pager used to display the table record.
- buttons used to:
- create a new record in the main file.
- delete the current record from the main file.
- close the page.
- add a row into the table.
- modify a row in the table.
- delete a row from the table.
The "Form with relation table" page is recommended when the details of the file must be displayed immediately. Semi-dynamic form This type of page is used to view a record and to browse the records to view. This type of page does not allow you to create or delete records. Indeed, when generating the associated static pages, one static page will be created per form. This type of page includes: - controls used to display the content of the file items.
- a navigation bar used to browse the records.
In most cases, the "Semi-dynamic form" page is accessible from a "Semi-dynamic table" page to view the current record. General case A table page displays the records in a table (rows and columns). Several file records can be displayed in the page. The items of the same record are displayed in row. Simple dynamic table This type of page is used to: - view the records in a table.
- create a record (in a form page)
- delete a record.
- modify a record (in a form page)
- print the file.
A "Simple dynamic table" page includes: - a table used to display the records found in the linked file.
- quick search controls used to access one of the table records.
- a pager used to browse the table records.
- buttons used to:
- create a new record.
- modify a record.
- delete a record.
- print the records.
- close the page.
This type of page is recommended in all the cases of file managementexcept: - if the details of the record must be displayed immediately: prefer a dynamic page with table and detailed form.
- if some items must be displayed in multiline controls: prefer a dynamic page with table and detailed form.
- if the file contains images that must be displayed immediately: prefer a dynamic page with table and detailed form.
- if the file contains a lot of items to display: prefer a dynamic page with table and detailed form.
- if linked items must be displayed: prefer a dynamic page with form and linked table.
Dynamic table with detailed form This type of page is used to view in the same page the content of a file in a table and in a form. This page is used to select a record in the table and to view the details of the selected record in a form. The "Dynamic table with detailed form" page includes: - a table (in the top section) used to display the file records.
- quick search controls used to access a record in the table
- a form (in the bottom section) used to display the values of the row selected in the table
- a pager used to browse the table records.
- several buttons used to:
- create a new record.
- modify the current record.
- delete the current record.
- close the page.
The "Dynamic table with detailed form" page recommended when: - the file contains image items or multiline items to display.
- the details of the record must be immediately visible.
- the file contains a lot of items to display.
Dynamic table with linked table This type of window is used to display in the same page the content of files linked by a simple or 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 "Dynamic table with linked table" page 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.
- two pagers used to browse the records in the tables.
- buttons used to:
- 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 page.
- add a row into the linked file.
- modify a row in the linked file.
- delete a row from the linked file.
Semi-dynamic table This type of page is used to view records in the table. The "Semi-dynamic table" page includes: - a table used to display the records found in the linked file.
- a pager used to browse the table records.
The "Semi-dynamic table" page is used to view the details of the records via a click performed on the record. Then, a "Semi-dynamic form" page is displayed. General case A Looper page displays the records in a repeated form (in a Looper control). Several records can be displayed in the page Dynamic looper This type of page is used to: - view the records in a browsing looper.
- create a record (in a form page)
- delete a record.
- modify a record (in a form page)
The "Dynamic looper" page includes: - a looper used to display the records found in the base file.
- quick search controls used to access a looper record.
- a pager control used to browse the records found in the looper.
- buttons used to:
- create a new record
- modify a record
- delete a record
- print a record
- close the page.
Semi-dynamic looper This type of page is used to view the records in a browsing looper. The "Semi-dynamic looper" page includes: - a looper used to display the records found in the base file.
- a button used to display the details of the current record
- a pager control used to browse the records found in the looper.
The Vision Plus pages are used to select a record in a table. For example, when entering an order, some Vision Plus pages can be opened to select the customer and the products. The Vision Plus pages are called by the button whose caption is [...] in the pages linked to a file. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|