PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • 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:
  • Browsing Table/Looper controls with direct access,
  • Memory Table/Looper controls,
  • Browsing Table/Looper controls loaded in memory.
Note: These three fill modes will be presented in this page 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 structure of data file was described in the data model editor and the data was typed in the application for example. 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 displayed data that is not linked to the data file is not kept when refreshing the display of Table control (when scrolling for example).
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 9
Comments
Click [Add] to post a comment