The different types of Table fields: programmatically, file with or without direct access

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

Overview
Features of Table controls

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

The different types of Table fields: programmatically, file with or without direct access

Overview

WINDEV, WEBDEV and WINDEV Mobile allow you to use:

Table controls populated programmatically.
Table controls linked to a data file with direct access to the data source.
Table fields linked to a data file loaded in memory. In this case, only a limited number of records is loaded in memory. If the data file contains more records than the number defined in the Table control description, a warning message appears: "There are more than XXX records. Only the first XXX rows will be displayed".

The table below presents the different features available (or not) for the different types of Table controls.

Note: The concept of a field based on a "data file loaded in memory" is also applicable:

List Box controls,
ListView controls,
Combo Box controls.

Features of Table controls

Feature	Table control populated programmatically	Table control linked to a data file with direct access to the data source	Table control linked to a data file loaded in memory

Automatically filled with the content of the data file		X	X
Automatically take into account the last filter implemented on the data file (HFilter)		X	X
Records are automatically added and modified in the data file.		X	X
Support for multi-selection.	X	X	X
Only the visible records are read.		X	X
Number of elements (Occurrence property) calculated by fetch if necessary		X	X
Sort and magnifier available for all the columns	X	X	X
Displays the last record or the middle record without reading all the previous records		X
Using the TableSave function		X	X
Use function TableDisplay with the following syntax: TableDisplay(TableName, taCurrentBand)		X	X
Data file positioned on the selection		X	X
Data file positioned during the "Display a row" event		X	X
Scrollbar with ongoing movement forbidden	X		X
Scrollbar tooltip on an item		X	X
Automatic refresh		X
Unlimited use of TableAddLine	X	X (*)	X
Using the TableRecNum function		X	X
Using the TableSearch function	X	Limited	X
Using the SQLTable function	X
Using the TableSelectToFile function		X	X
Ability to perform a manual iteration		X
Filter property		X
Managing the record locks		X	X
Re-reading the record during the selection		X
Re-reading the record when entering in input		X	X
Re-reading the records during the scroll		X
Support for large data files (over 100,000 records)		X
Support for compatibility with the tables in 5.5 format	X	X
Fatal error caused by an HFSQL problem during the initialization	According to code	X	X
Memory footprint	Everything is in memory	Low	Everything is in memory
Breaks	X		X
Selection by cell	X		X

(*) For Table fields on data files with direct access, if cascading input has been disabled, the TableAddLine function can be used to add a line to the field, allowing the user to enter data. In this case, TableAddLine can be called once only.

Table control with direct access to the data source and Table control with direct access to the data source are very similar. The main differences between these two types of controls are shown in bold.

Table fields on data files "with in-memory access" offer many advantages, including the ability to sort and search on any column in the field. They are also used to store the value of calculated columns for all the rows.