ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Developing an application or website / Controls, windows and pages / Controls: Available types / Table control
  • Overview
  • Features of Table controls
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
WINDEV, WEBDEV and WINDEV Mobile allow you to use:
  • Table controls populated programmatically.
  • Table controls based on a data file with direct access (called Table control based on a data file).
  • Table controls based on a data file loaded in memory. In this case, only a limited number of records is loaded in memory. If the data file contains more records than the number defined in the description of the Table control, a message is displayed to the user: "There are more than XXX records. Only the first XXX rows will be displayed".
The table below presents the different features available (or not) for the different types of Table controls.
Remark: The concept of control based on a "file loaded in memory" can also be applied to:
  • List Box controls,
  • ListView controls,
  • Combo Box controls.
Features of Table controls
FeatureTable control populated programmaticallyTable control with direct access to the data sourceTable control with in-memory data source
Automatically filled with the content of the data fileXX
Automatically take into account the last filter implemented on the data file (HFilter)XX
Records are automatically added and modified in the data file.XX
Support for multi-selection.XXX
Only the visible records are read.XX
Number of elements (..Occurrence) calculated by fetch if necessaryXX
Sort and magnifier available for all the columnsXX
Displays the last record or the middle record without reading all the previous recordsX
TableSave functionXX
Using TableDisplay with the following syntax: TableDisplay(TableName, taCurrentSelection)XX
Data file positioned on the selectionXX
Data file positioned during the event "Displaying a row"XX
Scrollbar with ongoing movement forbiddenXX
Scrollbar tooltip on an itemXX
Automatic refreshX
Unlimited use of TableAddLineXX *X
TableRecNum functionXX
TableSearch functionXLimitedX
SQLTable functionX
TableSelectToFile functionXX
Ability to perform a manual iterationX
Filter propertyX
Managing the record locksXX
Re-reading the record during the selectionX
Re-reading the record when entering in inputXX
Re-reading the records during the scrollX
Support large files (more than 100 000 records)X
Support for compatibility with the tables in 5.5 formatXX
Fatal error caused by an HFSQL problem during the initializationAccording to codeXX
Memory footprintEverything is in memoryLowEverything is in memory
BreaksXX
Selection by cellXX

(*) For Table controls based on a data file with direct access, if the cascading input was disabled, you can call TableAddLine to add a row to the control and allow users to enter data. In this case, TableAddLine can be called once only.
Table controls with in-memory data source are similar to standard Table controls. The main differences between these two types of controls are shown in bold.
Table controls with in-memory data source have multiple advantages, especially the ability to sort and search on any column. They are also used to store the value of calculated columns for all the rows.
Minimum version required
  • Version 12
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help