PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Notes
  • Limits for Android
  • Limits for iOS
  • Browsing table with direct access and Browsing table loaded in memory
  • Types of browsing Table controls
  • Limit in Java: Cascading input
  • Automatic synchronization (HFSQL Client/Server data)
  • Automatic viewing of linked records
  • Implementation via the window editor (automatic mode)
  • Implementation via the window editor (custom mode)
  • Implementation by programming
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
A browsing table control is a control whose columns are linked to items found in a data file or in a query (data source). Each Table control column can be:
  • Linked to an item of data source
  • Linked to an item of a file linked to the data source
  • Calculated: If the column is not linked to a file item, it is a calculated column. For the calculated columns, the content of the column is re-calculated whenever a row is displayed, it is not stored.
Each row found in the Table control corresponds to a record of the data source.
A browsing table control is used to:
  • View the content of a data file (or query) with one record per row and select a record (view the entire file or a selection of records selected according to a filter).
  • Versions 23 and later
    WINDEV View the content of linked records (for example, view the order lines associated with an order displayed in the Table control).
    New in version 23
    WINDEV View the content of linked records (for example, view the order lines associated with an order displayed in the Table control).
    WINDEV View the content of linked records (for example, view the order lines associated with an order displayed in the Table control).
  • Delete a record by deleting a row from the Table control.
  • Modify a record by modifying the content of a row found in the Table control.
  • Add a record by entering a row in the Table control.
  • Versions 23 and later
    WINDEVHFSQL Client/Server Automatically refresh the data modified from another computer.
    New in version 23
    WINDEVHFSQL Client/Server Automatically refresh the data modified from another computer.
    WINDEVHFSQL Client/Server Automatically refresh the data modified from another computer.
The number of records that can be viewed is unlimited, only the visible rows of Table control are loaded in memory.
WEBDEV - Server code Note: When creating a non-Ajax browsing Table control, a pager is automatically associated with this control. This pager is used to display the records found in the Table control.
Versions 20 and later
Android The browsing Table control is now available for the Android applications.
iPhone/iPad The browsing Table control is now available for the iPhone/iPad applications.
New in version 20
Android The browsing Table control is now available for the Android applications.
iPhone/iPad The browsing Table control is now available for the iPhone/iPad applications.
Android The browsing Table control is now available for the Android applications.
iPhone/iPad The browsing Table control is now available for the iPhone/iPad applications.

Notes

  • The browsing Table controls are used mainly to view data. To enter data, use the edit controls.
  • The row selected in the Table control corresponds to the current record in the data file. When changing row in the Table control, the current record in the data file is automatically modified.
Android

Limits for Android

  • The input is not available in the browsing Table controls. TableAdd, TableAddLine, TableInsert, TableInsertLine, TableModify and TableModifyLine are not available for the browsing Table controls.
  • Only the automatic browse is available for the browsing Table controls. The programmed browse is not available.
  • The browsing Table controls loaded in memory are not limited.
iPhone/iPad

Limits for iOS

The Table controls are available in read-only: the input is not available in this version.
Browsing table with direct access and Browsing table loaded in memory
WINDEVWEBDEV - Server codeAndroidiPhone/iPadWindows MobileJava

Types of browsing Table controls

Two types of browsing Table controls are available:
  • The browsing Table controls based on the file in direct access. These are the "standard" browsing Table controls.
  • The browsing Table controls based on a file loaded in memory. Only a specific number of file records (specified in the editor) are loaded in memory. These browsing Table controls are mainly used to perform sorts and searches on any column.
    Android You cannot define the number of records loaded in memory.
Java

Limit in Java: Cascading input

In Java, the cascading input is not available for the browsing Table controls with direct access. The cascading input is available for the browsing table controls loaded in memory only.
Versions 23 and later
WINDEV
Automatic synchronization (HFSQL Client/Server data)
A browsing Table control can be automatically refreshed, as soon as the associated HFSQL Client/Server data file is modified. This feature can be implemented:
  • in the editor:
    1. Display the description window of browsing Table control.
    2. In the "Content" tab, select the synchronization mode of display:
      Synchronizing the display
      • Never: No synchronization is performed (default case).
      • Modification only: The synchronization is performed when modifying a record.
      • Addition/Deletion only: The synchronization is performed when adding or deleting a record
      • Always: The synchronization is performed as soon as a write or delete operation is performed in the data file.
    3. Validate.
  • by programming: via ..SynchroHFSQL that can be used on the browsing Table control.
Caution: Enabling this feature increases the server load when displaying the Table control or when moving in the control.
New in version 23
WINDEV
Automatic synchronization (HFSQL Client/Server data)
A browsing Table control can be automatically refreshed, as soon as the associated HFSQL Client/Server data file is modified. This feature can be implemented:
  • in the editor:
    1. Display the description window of browsing Table control.
    2. In the "Content" tab, select the synchronization mode of display:
      Synchronizing the display
      • Never: No synchronization is performed (default case).
      • Modification only: The synchronization is performed when modifying a record.
      • Addition/Deletion only: The synchronization is performed when adding or deleting a record
      • Always: The synchronization is performed as soon as a write or delete operation is performed in the data file.
    3. Validate.
  • by programming: via ..SynchroHFSQL that can be used on the browsing Table control.
Caution: Enabling this feature increases the server load when displaying the Table control or when moving in the control.
WINDEV
Automatic synchronization (HFSQL Client/Server data)
A browsing Table control can be automatically refreshed, as soon as the associated HFSQL Client/Server data file is modified. This feature can be implemented:
  • in the editor:
    1. Display the description window of browsing Table control.
    2. In the "Content" tab, select the synchronization mode of display:
      Synchronizing the display
      • Never: No synchronization is performed (default case).
      • Modification only: The synchronization is performed when modifying a record.
      • Addition/Deletion only: The synchronization is performed when adding or deleting a record
      • Always: The synchronization is performed as soon as a write or delete operation is performed in the data file.
    3. Validate.
  • by programming: via ..SynchroHFSQL that can be used on the browsing Table control.
Caution: Enabling this feature increases the server load when displaying the Table control or when moving in the control.
Versions 23 and later
WINDEV
Automatic viewing of linked records
In a browsing table, you have the ability to expand a row to see the records of other data files, linked to the selected row.
Example:

Implementation via the window editor (automatic mode)

To allow the user to expand the rows found in a browsing Table control in order to see the linked records:
  1. Display the description window of browsing Table control.
  2. In the "Content" tab, check "Display a [ + ] for row details".
    The setting window is automatically displayed.
  3. In the setting window:
    • Check (if necessary) "Enable the display of linked data".
    • Select the "Automatic" display mode. In this mode, all the linked data files are proposed by the user.
    • Validate.
  4. Validate the description window of Table control.
When running the Table control, a popup menu allows the user to display the data linked to the data file currently displayed in the browsing Table control.
Note: the image of "+" displayed at the beginning of line can be customized:
  1. Display the description window of browsing Table control.
  2. In the "Style" tab:
    • Select the "Image [+]/[-] IW of row details" element.
    • Click the "Plus/Minus image of detailed Internal Window" button.
    • Select the image corresponding to the button and validate.

Implementation via the window editor (custom mode)

To allow the user to expand the rows found in a browsing Table control in order to see the linked records:
  1. Display the description window of browsing Table control.
  2. In the "Content" tab, check "Display a [ + ] for row details". The configuration window is automatically displayed.
  3. In the setting window:
    • Check (if necessary) "Enable the display of linked data".
    • Select the "Manual" display mode. In this mode, only the data found in a data file is proposed by the user. You have the ability to customize the data displayed.
    • Select the source item, found in the file displayed by the Table control.
    • Select the linked item, found in the linked data file.
    • Select the items that will be displayed in the viewing table of linked data. The "+" and "-" buttons are used to manage the data to display.
    • Validate.
  4. Validate the description window of Table control.
When running the Table control, a "+" sign allows the user to display the data linked to the data file currently displayed in the browsing Table control.
Note: the image of "+" displayed at the beginning of line can be customized:
  1. Display the description window of browsing Table control.
  2. In the "Style" tab:
    • Select the "Image [+]/[-] IW for row details" element.
    • Click the "Plus/Minus image of detailed Internal Window" button.
    • Select the image corresponding to the button and validate.

Implementation by programming

To allow the user to expand the rows found in a browsing Table control in order to see the linked records:
  1. Create a browsing Table control based on a data file or query.
  2. In the initialization code of Table control, use ..LinksLineDetails.
New in version 23
WINDEV
Automatic viewing of linked records
In a browsing table, you have the ability to expand a row to see the records of other data files, linked to the selected row.
Example:

Implementation via the window editor (automatic mode)

To allow the user to expand the rows found in a browsing Table control in order to see the linked records:
  1. Display the description window of browsing Table control.
  2. In the "Content" tab, check "Display a [ + ] for row details".
    The setting window is automatically displayed.
  3. In the setting window:
    • Check (if necessary) "Enable the display of linked data".
    • Select the "Automatic" display mode. In this mode, all the linked data files are proposed by the user.
    • Validate.
  4. Validate the description window of Table control.
When running the Table control, a popup menu allows the user to display the data linked to the data file currently displayed in the browsing Table control.
Note: the image of "+" displayed at the beginning of line can be customized:
  1. Display the description window of browsing Table control.
  2. In the "Style" tab:
    • Select the "Image [+]/[-] IW of row details" element.
    • Click the "Plus/Minus image of detailed Internal Window" button.
    • Select the image corresponding to the button and validate.

Implementation via the window editor (custom mode)

To allow the user to expand the rows found in a browsing Table control in order to see the linked records:
  1. Display the description window of browsing Table control.
  2. In the "Content" tab, check "Display a [ + ] for row details". The configuration window is automatically displayed.
  3. In the setting window:
    • Check (if necessary) "Enable the display of linked data".
    • Select the "Manual" display mode. In this mode, only the data found in a data file is proposed by the user. You have the ability to customize the data displayed.
    • Select the source item, found in the file displayed by the Table control.
    • Select the linked item, found in the linked data file.
    • Select the items that will be displayed in the viewing table of linked data. The "+" and "-" buttons are used to manage the data to display.
    • Validate.
  4. Validate the description window of Table control.
When running the Table control, a "+" sign allows the user to display the data linked to the data file currently displayed in the browsing Table control.
Note: the image of "+" displayed at the beginning of line can be customized:
  1. Display the description window of browsing Table control.
  2. In the "Style" tab:
    • Select the "Image [+]/[-] IW for row details" element.
    • Click the "Plus/Minus image of detailed Internal Window" button.
    • Select the image corresponding to the button and validate.

Implementation by programming

To allow the user to expand the rows found in a browsing Table control in order to see the linked records:
  1. Create a browsing Table control based on a data file or query.
  2. In the initialization code of Table control, use ..LinksLineDetails.
WINDEV
Automatic viewing of linked records
In a browsing table, you have the ability to expand a row to see the records of other data files, linked to the selected row.
Example:

Implementation via the window editor (automatic mode)

To allow the user to expand the rows found in a browsing Table control in order to see the linked records:
  1. Display the description window of browsing Table control.
  2. In the "Content" tab, check "Display a [ + ] for row details".
    The setting window is automatically displayed.
  3. In the setting window:
    • Check (if necessary) "Enable the display of linked data".
    • Select the "Automatic" display mode. In this mode, all the linked data files are proposed by the user.
    • Validate.
  4. Validate the description window of Table control.
When running the Table control, a popup menu allows the user to display the data linked to the data file currently displayed in the browsing Table control.
Note: the image of "+" displayed at the beginning of line can be customized:
  1. Display the description window of browsing Table control.
  2. In the "Style" tab:
    • Select the "Image [+]/[-] IW of row details" element.
    • Click the "Plus/Minus image of detailed Internal Window" button.
    • Select the image corresponding to the button and validate.

Implementation via the window editor (custom mode)

To allow the user to expand the rows found in a browsing Table control in order to see the linked records:
  1. Display the description window of browsing Table control.
  2. In the "Content" tab, check "Display a [ + ] for row details". The configuration window is automatically displayed.
  3. In the setting window:
    • Check (if necessary) "Enable the display of linked data".
    • Select the "Manual" display mode. In this mode, only the data found in a data file is proposed by the user. You have the ability to customize the data displayed.
    • Select the source item, found in the file displayed by the Table control.
    • Select the linked item, found in the linked data file.
    • Select the items that will be displayed in the viewing table of linked data. The "+" and "-" buttons are used to manage the data to display.
    • Validate.
  4. Validate the description window of Table control.
When running the Table control, a "+" sign allows the user to display the data linked to the data file currently displayed in the browsing Table control.
Note: the image of "+" displayed at the beginning of line can be customized:
  1. Display the description window of browsing Table control.
  2. In the "Style" tab:
    • Select the "Image [+]/[-] IW for row details" element.
    • Click the "Plus/Minus image of detailed Internal Window" button.
    • Select the image corresponding to the button and validate.

Implementation by programming

To allow the user to expand the rows found in a browsing Table control in order to see the linked records:
  1. Create a browsing Table control based on a data file or query.
  2. In the initialization code of Table control, use ..LinksLineDetails.
Related Examples:
Pocket Attendance Mobile (WINDEV Mobile): Pocket Attendance
[ + ] This application is an attendance manager. It allows you to list the persons who attended a meeting.
The database is previously filled with the list of registered persons.
A bar code reader can be used to read the identifiers of the persons.
The following topics are presented in this example:
1/ the click performed on a table column
2/ the use of a browsing table
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment