ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / Developing an application or website / Controls, windows and pages / Controls: Available types / Table control / Data-bound Table
  • Overview
  • Notes
  • Limitations for Android
  • Limitations for iOS
  • Direct-access Table field and memory-loaded Table field
  • The different types of Table controls
  • Java limitation: Cascading input
  • Automatic synchronization (HFSQL Client/Server data)
  • Automatic view of bound records
  • Implementation via the window editor (automatic mode)
  • Implementation via the window editor (custom mode)
  • Implementation programmatically
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Overview
A Table control linked to a data file is a field whose columns are linked to fields in a data file or query. The data file and the query are considered to be the data source.
Each Table control column can be:
  • Bound to an item of the data source.
  • Linked to a field in a data file linked to the data source.
  • Calculated: If the column is not linked to a field in a data file, it is a calculated column. calculated column. For calculated columns, the content of the column is recalculated each time a row is displayed.
Each row in the Table control corresponds to a record of the data source.
A Table control linked to a data file allows you 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).
  • WINDEV View the content of bound 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.
  • WINDEVHFSQL Client/Server Automatically refresh the data modified from another computer.
The number of records that can be viewed is unlimited, but only the visible rows in the Table control are loaded in memory.
WEBDEV - Server code Note When creating a non-Ajax data-bound Table control file, an slider is automatically associated with this field. This pager is used to display the records from the Table control.

Notes

  • Table control fields linked to a data file are mainly used to display data. To enter data, use the Edit controls.
  • The row selected in the Table control corresponds to the current record in the data file. If the position is set to a different row in the Table control, the position in the data file also changes to the corresponding record.
Android

Limitations for Android

  • Edit control is not available in Table fields linked to a data file. The functions TableAdd, TableAddLine, TableInsert, TableInsertLine, TableModify and TableModifyLine are not available on this field type.
  • Only automation is available in Table control fields linked to a data file. Iterations set programmatically are not available.
  • Table controls linked to a "memory-loaded" data file are not restricted.
iPhone/iPad

Limitations for iOS

Table fields are available for viewing only: editing is not available in this version..
Direct-access Table field and memory-loaded Table field
WINDEVWEBDEV - Server codeAndroidiPhone/iPadJava

The different types of Table controls

There are two types of Table control fields linked to a data file:
  • Table controls linked to a direct-access data file.
    The Table control displays the entire data file. This type of field can be used to load very large data files. Low memory occupancy.
    New in version 2025
    WINDEV Table controls linked to a data file with direct access feature sorting and magnifying on all columns (if the number of records is less than 100,000 and the field does not use a bounce scrollbar).
    Attention This feature is only available from version 2025 Update 2.
  • Table controls based on a data file loaded into memory. Only a specific number of records from the data file (defined in the editor) are loaded into memory. These Table controls can be used to sort and search on any column.
    Android You cannot define the number of records loaded in memory.
For more details on these two types of Table control fields, see Comparison between the features of Table controls.
Java

Java limitation: Cascading input

In Java, cascading is not available for Table controls with direct access to the data source. Cascading is only available for Table controls based on a data file loaded in memory.
WINDEV
Automatic synchronization (HFSQL Client/Server data)
A Table control linked to a data file can refresh automatically as soon as the associated HFSQL Client/Server data file is modified. This feature can be defined:
  • in the editor:
    1. Open the Table control description window.
    2. On the "Content" tab, select the display synchronization mode:
      Synchronizing the display
      • Never: No synchronization is performed (default case).
      • Modification only: Synchronization takes place only when a Record is modified.
      • Add/Delete only: Synchronization takes place only when a record is added or deleted.
      • Always: Synchronization is performed as soon as a write or delete operation is performed in the data file.
    3. Validate.
  • programmatically: using the SynchroHFSQL property on the Table control field.
The automatic synchronization is performed:
  • between the different instances of the same application on a computer or different computers,
  • between different applications on one or multiple computers,
  • between the different windows of the same application, whether or not the HFSQL context is the same between the windows.
Caution: Enabling this feature increases server load when displaying the Table control or when moving within the field.
WINDEV
Automatic view of bound records
In a Table control linked to a data file, you can scroll down a line to view the records of other data files linked to the selected line.
Example:
Bound records

Implementation via the window editor (automatic mode)

To allow the user to scroll down the lines of a Table control to view related records:
  1. Open the Table control description window.
  2. On the "Content" tab, check "Show row details with [ + ]".
    Show details
    The settings window appears automatically.
  3. In the settings window:
    Automatically bound records
    • If necessary, check "Display bound data".
    • Select the "Automatic" display mode. In this mode, all related data files are shown to the user.
    • Validate.
  4. Validate the Table control description window.
When the Table control is run, a context menu is available to display the various data related to the data file currently displayed in the Table control.
Bound records
Bound records
Note: the image of the "+" displayed at the beginning of the line can be customized:
  1. Open the Table control description window.
  2. In the "Style" tab:
    • Select "[+]/[-] image IW for row details".
    • Click the "Plus/Minus image of the details 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 rows in a data-bound Table control to see the bound records:
  1. Open the Table control description window.
  2. On the "Content" tab, check "Show row details with [ + ]". The settings window appears automatically.
  3. In the settings window:
    • If necessary, check "Display bound data".
    • Select the "Manual" display mode. In this mode, only the data from one data file is shown to the user. You can customize the data to be displayed.
    • Select the source item in the data file displayed by the Table control.
    • Select the bound item in the linked data file.
    • Select the items that will be displayed in the table of bound data. You can use the and buttons to choose the information to be displayed.
      Selecting row details
    • Validate.
  4. Validate the Table control description window.
At runtime, a "+" sign allows the user to see the data related to the data file currently displayed in the Table control.
Details view
Note: the image of the "+" displayed at the beginning of the line can be customized:
  1. Open the Table control description window.
  2. In the "Style" tab:
    • Select "[+]/[-] image IW for row details".
    • Click the "Plus/Minus image of the details internal window" button.
    • Select the image corresponding to the button and validate.

Implementation programmatically

To allow the user to scroll down the lines of a Table control to view related records:
  1. Create a Table control based on a data file or query.
  2. In the Table control initialization code, use the RowDetailsBinding property.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 04/09/2025

Send a report | Local help