PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Automatic browsing Table control
  • Programming a programmed Browsing Table control
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Table control linked to a data file or to a query
ODBCNot available with this kind of connection
Overview
A Table control can be used to display the content of a data file or the content of a query: the user can select one or more records from this file or query.
A Table control can be linked 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: 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 linked to a data file or to a query, the Table control can be initialized with the content of the file:
  • automatically: No specific code is required to initialize the Table control. The characteristics of the browse performed in the file linked to the control are described in the "Content" tab of the description window of the Table control.
  • by programming: The code used to browse the data file linked to the Table control must be entered in the different codes of the Table control. This method is not recommended.
    AndroidiPhone/iPad This method is not available.
Note: When creating a Table control, the wizard asks for the information required to create the link between the control and a data file or a query.
Versions 20 and later
Android The Table control is now available for the Android applications.
iPhone/iPad The Table control is now available for the iPhone/iPad applications.
New in version 20
Android The Table control is now available for the Android applications.
iPhone/iPad The Table control is now available for the iPhone/iPad applications.
Android The Table control is now available for the Android applications.
iPhone/iPad The Table control is now available for the iPhone/iPad applications.
Automatic browsing Table control
A browsing Table control is used to display data coming from a specific data source (data file, query, ...).
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 is used 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
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.
  • Search 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
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 search key 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.
Android The filtering options are not available for the browsing Table controls with direct access.
WINDEVWINDEV Mobile Display the content while moving the scrollbar
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.
WINDEVWINDEV Mobile Use HFilter to browse the file
Allows you to filter the records displayed in the Table control and the base data file of the control. See Filter in the browsing Table controls for more details.
Android The filtering options are not available for the browsing Table controls with direct access.
Programming a programmed Browsing Table control
If you are using a Table control based on a file with programmed initialization, the code for file browse must be entered in the different processes associated with the control. This method is not recommended and it is kept for backward compatibility.
For example: Initializing a Table control with the customers found in CUSTOMER file.
// Initialize the Table control
HReadFirst(CUSTOMER, LASTNAME)

// Previous record
HReadPrevious(CUSTOMER, NAME)
// Next record
HReadNext(CUSTOMER, LASTNAME)
// Last record
HReadLast(CUSTOMER, NAME)
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment