PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
New WEBDEV 24 feature!
  • Browsing Table control with direct access
  • Memory Table control
  • Browsing Table control loaded in memory
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
11. The Table/Looper controls
Previous pageTable of contentsNext page
The Table/Looper controls can be used to display a set of information (the content of a data file for example). The content of these controls can come from three different sources:
Note: These three fill modes will be presented in details for the Table control. The same concepts apply to the Looper control.
Browsing Table control with direct access
A browsing Table control with direct access is used to directly display the data coming from a data file or from a query. The data file structure was described in the data model editor and the data was typed in the site.
Browsing the data file allows you to display data in the Table control. The data file is read for each row displayed: the record read is displayed in a row of Table control.
The number of records displayed in the control can be limited by a filter (HFilter used in the initialization code of control).
Several WLanguage functions can be used to handle the browsing Table controls. These functions start with "Table".
To add a record into the Table control, add the record into the corresponding HFSQL data file (HAdd), and redisplay the Table control with TableDisplay.
To delete a record from the Table control, delete the record from the corresponding HFSQL data file (HDelete) and redisplay the Table control with TableDisplay.
Memory Table control
A memory Table control is used to directly display the data loaded in memory. The data is added into the Table control by programming (by TableAddLine for example).
The data being found in memory, the Table control allows you to perform all operations on the data (sort on any column, search in the columns, ...)
Browsing Table control loaded in memory
The browsing Table controls loaded in memory combine the benefits of browsing Table controls with direct access with the benefits of memory Table controls.
The Table control is linked to the data file but the content of data file is entirely loaded in memory. The sort and the search are available for all columns.
The data not linked to the data file is kept when handling the scrollbar (Check Box column for example).
The file records being loaded in memory, this type of control is recommended for the data files containing less than 100 000 records (to avoid memory overflow).
Note: The different fill modes (memory, browsing, browsing loaded in memory) are available for the List Box controls, Combo Box controls, Table controls, Looper controls, ...
Previous pageTable of contentsNext page
Minimum version required
  • Version 24
Comments
Click [Add] to post a comment