|
|
|
|
|
|
|
|
- Overview
- Features of Table controls
The different types of Table controls: populated programmatically, with or without access to the data source
WINDEV, WEBDEV and WINDEV Mobile allow you to use: - Table controls populated programmatically.
- Table controls based on a data file with direct access (called Table control based on a data file).
- Table controls based on 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 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: - List Box controls,
- ListView controls,
- Combo Box controls.
Features of Table controls | | | | | Feature | Table control populated programmatically | Table control with direct access to the data source | Table control with in-memory data source |
|---|
| 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 | | | TableSave function | | 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 | | TableRecNum function | | X | X | | TableSearch function | X | Limited | X | | SQLTable function | X | | | | 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 large files (more than 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 controls based on a data file with direct access, if the cascading input was disabled, you can call TableAddLine to add a row to the control and allow users to enter data. In this case, TableAddLine can be called once only. Table controls with in-memory data source are similar to standard Table controls. The main differences between these two types of controls are shown in bold. Table controls with in-memory data source have multiple advantages, especially the ability to sort and search on any column. They are also used to store the value of calculated columns for all the rows.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|