Table field linked to a data file (Table file)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / Developing an application or website / Controls, windows and pages / Controls: Available types / Table control / Data-bound Table

Overview
Notes
Limitations for Android
Limitations for iOS
Direct-access Table field and memory-loaded Table field
The different types of Table controls

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Table field linked to a data file (Table file)

Not available with this kind of connection

Overview

A Table control linked to a data file is a field whose columns are linked to fields in a data file or query. The data file and the query are considered to be the data source.

Each Table control column can be:

Bound to an item of the data source.
Linked to a field in a data file linked to the data source.
Calculated: If the column is not linked to a field in a data file, it is a calculated column. calculated column. For calculated columns, the content of the column is recalculated each time a row is displayed.

Each row in the Table control corresponds to a record of the data source.

A Table control linked to a data file allows you 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.
Automatically refresh the data modified from another computer.

The number of records that can be viewed is unlimited, but only the visible rows in the Table control are loaded in memory.

Notes

Table control fields linked to a data file are mainly used to display data. To enter data, use the Edit controls.
The row selected in the Table control corresponds to the current record in the data file. If the position is set to a different row in the Table control, the position in the data file also changes to the corresponding record.

Limitations for Android

Edit control is not available in Table fields linked to a data file. The functions TableAdd, TableAddLine, TableInsert, TableInsertLine, TableModify and TableModifyLine are not available on this field type.
Only automation is available in Table control fields linked to a data file. Iterations set programmatically are not available.
Table controls linked to a "memory-loaded" data file are not restricted.

Limitations for iOS

Table fields are available for viewing only: editing is not available in this version..

Direct-access Table field and memory-loaded Table field

The different types of Table controls

There are two types of Table control fields linked to a data file:

Table controls linked to a direct-access data file.
The Table control displays the entire data file. This type of field can be used to load very large data files. Low memory occupancy.
Table controls based on a data file loaded into memory. Only a specific number of records from the data file (defined in the editor) are loaded into memory. These Table controls can be used to sort and search on any column.
You cannot define the number of records loaded in memory.

For more details on these two types of Table control fields, see Comparison between the features of Table controls.