PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

  • Overview
  • Notes
  • Browsing table with direct access and Browsing table loaded in memory
  • Types of browsing Table controls
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
Overview
A browsing Table control is a control whose columns are linked to items found in a data file or in a query (data source). Each Table control column can be:
  • Linked to an item of data source
  • Linked to an item of a file linked to the data source
  • Calculated: If the column is not linked to a file item, it is a calculated column. For the calculated columns, the content of the column is re-calculated whenever a row is displayed, it is not stored.
Each row found in the Table control corresponds to a record of the data source.
A browsing table 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.
  • Versions 23 and later
    HFSQL Client/Server Automatically refresh the data modified from another computer.
    New in version 23
    HFSQL Client/Server Automatically refresh the data modified from another computer.
    HFSQL Client/Server Automatically refresh the data modified from another computer.
The number of records that can be viewed is unlimited, only the visible rows of Table control are loaded in memory.
WEBDEV - Server code Note: When creating a non-Ajax browsing Table control, a pager is automatically associated with this control. This pager is used to display the records found in the Table control.

Notes

  • The browsing Table controls are used mainly 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. When changing row in the Table control, the current record in the data file is automatically modified.
Browsing table with direct access and Browsing table loaded in memory
WEBDEV - Server code

Types of browsing Table controls

Two types of browsing Table controls are available:
  • The browsing Table controls based on the file in direct access. These are the "standard" browsing Table controls.
  • The browsing Table controls based on a file loaded in memory. Only a specific number of file records (specified in the editor) are loaded in memory. These browsing Table controls are mainly used to perform sorts and searches on any column.
Related Examples:
Pocket Attendance Mobile (WINDEV Mobile): Pocket Attendance
[ + ] This application is an attendance manager. It allows you to list the persons who attended a meeting.
The database is previously filled with the list of registered persons.
A bar code reader can be used to read the identifiers of the persons.
The following topics are presented in this example:
1/ the click performed on a table column
2/ the use of a browsing table
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment