ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Reports & Queries: Specific features
This help page presents the specific features of "Reports & Queries" (which means the user version of report editor) ......
HExecuteView (Function)
Runs a view that was created beforehand (can be used to refresh the view data for example). This function uses the former view mechanism.
REP files
REP files contain the list of data files handled by the application....
HToFile (Function)
Copies a data source (file, query, view, ...) to a physical HFSQL file with the same description. This file is neither encrypted nor password protected.
<Source>.FromPage (Function)
Automatically updates: the value of the items in a data file with the value of the controls in the page. the value of the WLanguage variables with the value of the page controls....
SourceFromPage (Function)
Automatically updates: the value of the items in a data file with the value of the controls in the page. the value of the WLanguage variables with the value of the page controls....
FileToMemoryTable (Function)
Populates a Table control programmatically with the records from a data file, HFSQL view or query (query created in the query editor or with HExecuteSQLQuery).
The tables in a report
In a report, a table includes a set of controls called "Table cells"......
SQL set operations: UNION, UNION ALL and INTERSECT
SQL allows performing set operations on groups of files......
SQL statements
The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows......
WDTestSite: Overview
WDTestSite is used to run different tests on a WEBDEV site......
FOR ALL/FOR EACH statement (browse of strings)
The FOR EACH statement is used to browse strings according to different methods...
HFSQL Control Center: HFSQL Client/Server backups
The HFSQL Control Center is used to manage the backups of HFSQL Client/Server data files......
France.CheckINSEE (Function)
Tests the validity of an INSEE number (identification number of physical persons assigned by the National Institute of Statistics and Economic Studies - Institut National de la Statistique et des Etudes Economiques).
SQL view
An SQL view is a virtual data source defined by an SQL query......
Native Informix Connector: Programming with HFSQL functions
To use an Informix database with the Native Connector, import the structure of Informix tables into the WINDEV or WEBDEV analysis......
Native Sybase Connector: Programming with HFSQL functions
To use a Sybase database with Native Connector, the structure of Sybase tables must be imported into the WINDEV or WEBDEV analysis......
Multi-database queries
A query (typed in SQL code) can operate on different databases......
7. Sending an email
WINDEV Tutorial: WINDEV application: Managing data Lesson 7 - Sending an email - 20 min
Accessing Outlook
WINDEV and WEBDEV allow you to easily access the data handled by Outlook......
Type of windows created by RAD
The wizard for window creation proposes several types of windows associated with HFSQL data files......
Pivot Table control in a report
The report editor allows you to create "Crosstab" reports......
Database parameters (Setup program)
The setup program creation wizard includes the setup of the database along with the application and suggests additional elements......
FOR EACH/FOR ALL statement (browse of arrays)
The FOR EACH statement is used to perform different types of browse on the arrays...
IF statement
The conditional IF statement allows you to run an action according to a condition...