Home | Sign in | English EN
This content has been translated automatically. Click here to view the French version.
  • Overview
  • Automatic browsing Table control
  • Programming a programmed Browsing Table control
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Stored procedures
Table control bound to a data file or query
ODBCNot available with this kind of connection
A Table control can be used to display the content of a data file or the content of a query: a user can select one or more records from this data file or query.
A Table control can be bound to:
  • an existing query: all you have to do is select this query among the queries of your project.
  • a query included in the Table control: this query will be created in the wizard for creating the Table control. This query will be available for this control only.
When a Table control is bound to a data file or query, the control can be updated with the data from the data file:
  • automatically: No specific code is required to initialize the Table control. The characteristics of how the data file bound to the control is looped through are described in the "Content" tab of the Table control description.
  • by programming: The code used to loop through the data file bound to the Table control must be entered in the different events of the Table control. This method is not recommended.
Remark: When creating a Table control, the wizard requests the necessary information to bind the control to a data file or query.
Automatic browsing Table control
A browsing Table control is used to display data coming from a specific data source (data file, query, etc.).
The content of the Table control is defined during its creation and it can be modified in the description window of the control ("Content" tab).
This screen allows you to define whether the Table control is a browsing or memory Table control. For a browsing Table control, this screen is used to define the characteristics of the browse performed in the data source:
  • Browsed file
File or query containing the data to display.
If the Table control is based on an embedded query, the name of the browsed file has the following format: <Window Name>_<Number>$Query. In this case, all the options of the "Embedded query" button are available.
  • Stored item (optional)
Item whose value is returned to the program when a row is selected in the Table control.
  • Automatic browse (described below)
If this option is checked, the runtime engine manages the file browse and the display of data in the Table control. No WLanguage code is required.
  • Browse item
Item used to browse the data source. The records displayed in the Table control will be sorted according to this item.
If <Automatic> is selected, the HFSQL engine will automatically select the best search key.
  • Reverse browse (descending)
The browse direction depends on the search item. The browse direction was defined in the data model editor, in the characteristics of the item.
If this option is checked, the browse direction used will be the reverse of the one defined in the data model editor.
  • Display the records whose browse item starts with
Condition used to filter the displayed records. This filter is a "Start with" filter and it is applied to the search item. To implement more complex filters, use HFilter. See Filter in the browsing Table controls for more details.
If this option is checked, the size of the cursor for the vertical scrollbar will be proportional to the number of elements found in the Table control.
Allows you to filter the records displayed in the Table control and the base data file of the control. For more details on this option, see Filter in the browsing Table controls.
This option automatically refreshes the browsing Table control as soon as the associated Client/Server HFSQL data file is modified..
This option allows you to expand a row in the Table control to see records from other data files that are bound to the selected row.
Programming a programmed Browsing Table control
If you use a Table control based on a data file with programmed initialization, the code to browse the data file must be entered in the different events associated with the control. This method is not recommended and it is kept for backward compatibility.
For example: Initialization of a Table control with the customers of the CUSTOMER data file.
// Initialisation du champ Table
HLitPremier(CLIENT, NOM)
// Enregistrement précédent
HLitPrécédent(CLIENT, NOM)
// Enregistrement suivant
HLitSuivant(CLIENT, NOM)
// Dernier enregistrement
HLitDernier(CLIENT, NOM)
Minimum version required
  • Version 9
This page is also available for…
Click [Add] to post a comment