The browsing Table control

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Help

Overview

Browsing table with direct access and Browsing table loaded in memory

Related examples

See also

The browsing Table control

Not available with this kind of connection

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
Automatically refresh the data modified from another computer.
New in version 23
Automatically refresh the data modified from another computer.
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

The browsing Table control is now available for the Android applications.

The browsing Table control is now available for the iPhone/iPad applications.

New in version 20

The browsing Table control is now available for the Android applications.

The browsing Table control is now available for the iPhone/iPad applications.

The browsing Table control is now available for the Android applications.

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.

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.

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

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

See Comparison between the features of Table controls for more details.

Related Examples:

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