• Overview
  • Features of Table controls
WinDevWebDev-服务器代码WebDev-浏览器代码WinDev Mobile报表和查询
WindowsLinuxWindows MobileWindows PhoneWindows Store appsAndroidAndroid Widget iPhone/iPad
HFSQLHFSQL Client/Server存储过程HF 5.5OLE DBODBC本地访问

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

WinDev, WebDev and WinDev Mobile allow you to use:
  • memory Table controls.
  • browsing Table controls with direct access (called browsing tables).
  • browsing Table controls with data file loaded in memory. In this case, only a limited number of records is loaded in memory. A message informs the user if the data file contains more records than the number defined in the description of a Table control: "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 control based on a "file loaded in memory" can also be applied to:

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

Features of Table controls
FeatureMemory Table controlBrowsing Table control with direct access fileBrowsing Table control with file loaded in memory
Automatically filled with the content of the data fileXX
Automatically taking into account the last filter implemented on the file (H过滤器)XX
Automatic addition and modification of records in the data file.XX
Support for multi-selection.XXX
Read the visible records only.XX
Number of elements (..数目) calculated by fetch if necessaryXX
Sort and magnifier available for all the columnsXX
Displays the last record or the middle record without reading all the previous recordsX
Using 表格保存XX
Using 表格显示 with the following syntax: 表格显示(TableName, taCurrentSelection)XX
File positioned on the selectionXX
Data file positioned during the "Row display" processXX
Scrollbar with ongoing movement forbiddenXX
Scrollbar tooltip on an itemXX
Automatic refreshX
Unlimited use of 表格添加行XX *X
Using 表格记录号XX
Using 表格查找数据XLimitedX
Using SQL表X
Using 表格选定行定位到数据库表XX
Ability to perform a manual browseX
Using ..过滤器X
Managing the record locksXX
Re-read the record during the selectionX
Re-read the record when entering in inputXX
Re-read the records during the scrollX
Support of huge files (containing over 100 000 records)X
Support for compatibility with the tables in 5.5 formatXX
Fatal error caused by a HFSQL problem during the initializationDepends on the codeXX
Memory footprintEverything is in memoryLowEverything is in memory
Selection to the cellXX

(*) For the browsing Table control with direct access, if the cascading input was disabled, you have the ability to call 表格添加行 in order to add a row to the control and to allow the use to perform his input. In this case, 表格添加行 can be called once only.The "standard" browsing Table controls and the browsing Table controls "with memory access" 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 the calculated columns for all the rows.