PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • Overview
  • Notes
  • Limits for Android
  • Limits for iOS
  • 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.
Versions 20 and later
Android The browsing Table control is now available for the Android applications.
iPhone/iPad The browsing Table control is now available for the iPhone/iPad applications.
New in version 20
Android The browsing Table control is now available for the Android applications.
iPhone/iPad The browsing Table control is now available for the iPhone/iPad applications.
Android The browsing Table control is now available for the Android applications.
iPhone/iPad The browsing Table control is now available for the iPhone/iPad applications.

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.
Android

Limits for Android

  • The input is not available in the browsing Table controls. TableAdd, TableAddLine, TableInsert, TableInsertLine, TableModify and TableModifyLine are not available for the browsing Table controls.
  • Only the automatic browse is available for the browsing Table controls. The programmed browse is not available.
  • The browsing Table controls loaded in memory are not limited.
iPhone/iPad

Limits for iOS

The Table controls are available in read-only: the input is not available in this version.
Browsing table with direct access and Browsing table loaded in memory
AndroidiPhone/iPadWindows Mobile

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.
    Android You cannot define the number of records loaded in memory.
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