Table field linked to a data file (Table file)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

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

WEBDEV

WINDEV Mobile

Others

See also

Table field linked to a data file (Table file)

Not available with this kind of connection

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).
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.
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.

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.

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.

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

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
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.
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 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.

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:
  - 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.

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:

Implementation via the window editor (automatic mode)

To allow the user to scroll down the lines of a Table control to view related records:

Open the Table control description window.
On the "Content" tab, check "Show row details with [ + ]".

The settings window appears automatically.
In the settings window:
- If necessary, check "Display bound data".
- Select the "Automatic" display mode. In this mode, all related data files are shown to the user.
- Validate.
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.

Note: the image of the "+" displayed at the beginning of the line can be customized:

Open the Table control description window.
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:

Open the Table control description window.
On the "Content" tab, check "Show row details with [ + ]". The settings window appears automatically.
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.
- Validate.
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.

Note: the image of the "+" displayed at the beginning of the line can be customized:

Open the Table control description window.
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:

Create a Table control based on a data file or query.
In the Table control initialization code, use the RowDetailsBinding property.