ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Developing an application or website / Controls, windows and pages / Controls: Available types / Table control / Table based on a data file
  • Overview
  • Notes
  • Table controls with direct access to the data source and with in-memory data source
  • Types of Table controls based on a data file
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Overview
A Table control based on a data file is a control whose columns are bound to the items of a data file or query (data source). Each Table control column can be:
  • Bound to an item of the data source.
  • Bound to an item of a data file related to the data source.
  • Calculated: If the column is not bound to a data file item, then it is a 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 based on a data file 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).
  • 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.
  • HFSQL 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 Remark: When creating a non-Ajax Table control based on a data file, a pager is automatically associated with this control. This pager is used to display the records from the Table control.

Notes

  • Table controls based on a data file are mainly used 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. 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.
Table controls with direct access to the data source and with in-memory data source
WEBDEV - Server code

Types of Table controls based on a data file

There are two types of Table controls based on data files:
  • Table controls with direct access to the data source. These are the "standard" Table controls based on a data file.
  • Table controls with in-memory data source. Only a specific number of file records (specified in the editor) are loaded in memory. These Table controls are mainly used to perform sorts and searches on any column.
For more details on these two types of Table controls, see Comparison between the features of Table controls.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/03/2023

Send a report | Local help