The different types of Table controls: memory, browsing with or without direct access

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

Editors

Controls (window/page/report)

The different types of Table controls: memory, browsing with or without direct access

Overview

Features of Table controls

See also

AAF: Automatic filter on the columns of Table controls

AAF: Handling the columns of a Table control

AAF: Increasing the height of the rows in the Table or Looper controls

Break in a Table control

Characteristics of Table controls in a page

Characteristics of Table controls in a window

Combo Box columns in the Table controls

Combo Box columns in the Table controls (prefixed syntax)

Content of Table control

Customizing the interface of a Table control

Events associated with Table controls

Managing the colors in the Table controls

Popup menu associated with Table controls and their columns (AAF)

Programming custom calculations in Table controls

Programming custom calculations in Table controls (prefixed syntax)

Properties associated with the Table control

Properties associated with the breaks of a Table control

The Table control

The Table control on mobile (Android and iOS)

The Table controls in AJAX mode

The different types of Table controls: memory, browsing with or without direct access

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

Overview
Features of Table controls

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

The different types of Table controls: memory, browsing with or without direct access

Overview

WINDEV, WEBDEV and WINDEV Mobile allow you to use:

memory Table controls.
browsing Table controls with direct access (called browsing Table control).
browsing Table controls with 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 description of the Table control, a message is displayed to the user: "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.

Remark: The concept of control based on a "file loaded in memory" can also be applied to:

the List Box controls,
the ListView controls,
the Combo Box controls.

Versions 20 and later

The Table control is now available for Android applications.

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

New in version 20

The Table control is now available for Android applications.

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

The Table control is now available for Android applications.

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

Features of Table controls

Feature	Memory Table control	Browsing Table control with direct access file	Browsing Table control with 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) calculated by fetch if necessary		X	X
Sort and magnifier available for all the columns	X		X
Displays the last record or the middle record without reading all the previous records		X
Using TableSave		X	X
Using TableDisplay with the following syntax: TableDisplay(TableName, taCurrentSelection)		X	X
Data file positioned on the selection		X	X
Data file positioned during the event "Displaying a row"		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 TableRecNum		X	X
Using TableSeek	X	Limited	X
Using SQLTable	X
Using TableSelectToFile		X	X
Ability to perform a manual browse		X
Using Filter		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 the huge files (more than 100 000 records)		X
Support for compatibility with the tables in 5.5 format	X	X
Fatal error caused by a 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 direct access browsing Table controls s, if cascading input has been disabled, the TableAddLine function can be used to add an row to the control to allow the user to enter. In this case, TableAddLine can be called once only.

The "standard" browsing Table controls and the browsing Table controls "with access in memory" are very close. The main differences between these two types of controls are shown in bold.

The browsing Table controls "with memory access" provide several benefits, especially the ability to perform sorts and searches on any column of the control. They are also used to store the value of calculated columns for all the rows.