Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
  • Overview
  • Features of Table controls
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
WINDEV, WEBDEV and WINDEV Mobile allow you to use:
  • memory Table controls.
  • browsing Table controls with direct access (called browsing Table control).
  • browsing Table controls with 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:
  • the List Box controls,
  • the ListView controls,
  • the Combo Box controls.
Features of Table controls
FeatureMemory Table controlBrowsing Table control with direct access fileBrowsing Table control with file loaded in memory
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
Using TableSaveXX
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
Using TableRecNumXX
Using TableSeekXLimitedX
Using SQLTableX
Using TableSelectToFileXX
Ability to perform a manual browseX
Using FilterX
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 the huge 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
Selection by cellXX

(*) For direct access browsing Table controls s, if cascading input has been disabled, the TableAddLine function can be used to add an row to the control to allow the user to enter. In this case, TableAddLine can be called once only.
The "standard" browsing Table controls and the browsing Table controls "with access in memory" are very close. The main differences between these two types of controls are shown in bold.
The browsing Table controls "with memory access" provide several benefits, especially the ability to perform sorts and searches on any column of the control. 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…
Click [Add] to post a comment