ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Mathematical SQL functions
The mathematical SQL functions that can be used on the queries written in SQL code are as follows...
Informix Native Connector: Programming using SQL functions
The use of SQL functions to manipulate Informix data does not require importing the file structure into the database schema...
SQL : ORDER BY clause: Organizing the result of a query
The ORDER BY clause is used to sort the records selected by an SQL query...
Creating a query in SQL code
The query editor allows you to create a query by typing SQL code...
SQL functions that can be used in SQL queries
The following SQL functions can be used on the queries written in SQL code (classified by theme)...
SQL commands available in an SQL query
WINDEV allows you to easily run queries in SQL code...
SQL statements
The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows...
SQL selection conditions
To specify the selection conditions in an SQL query, you can use...
SQL: Managing joins (INNER JOIN, OUTER JOIN)
To select records coming from several data files, joins must be used in the SQL query...
DB2 Native Connector: Programming with SQL functions
The use of SQL functions to handle DB2 data does not require importing the table structure into the database schema...
Overloading a WLanguage function or using a WLanguage function in an SQL query
WLanguage includes the "WL" keyword...
<Source>.ExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
DB2 Native Connector: Features and notes
The following paragraphs present the main aspects and specific features of the Native DB2 Connector...
Native Oracle Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer an optional Native Oracle Connector (also called Native Oracle Access...
Native MariaDB Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer a Native Access Connector to MariaDB ...
Native PostgreSQL Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer a Native Connector to PostgreSQL...
Accessing a database in local mode (SQLite)
WEBDEV allows a site to create and access a database created by the browser on the computer of the Web user in browser code.
Extensions of files created by WINDEV, WEBDEV, WINDEV Mobile
The table below presents the main extensions of files created and supported by WINDEV, WEBDEV and WINDEV Mobile...
Native MySQL Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer a Native Connector for MySQL...
Informix Native Connector: Features and notes
Remarks and specific features of Native Informix Connector
Native Progress Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer an optional Native Connector to Progress ...
Native DB2 Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer an optional Native Connector to DB2...
Native Informix Connector for WINDEV and WEBDEV
As an option, WINDEV and WEBDEV offer an Informix Native Connector (also known as Native Access...
Native Oracle Connector: Retrieving the output value of a stored procedure
The Native Oracle Connector is used to: specify the input values during the call to a stored...
WDOptimizer: Overview
The different operations that can be performed with WDOptimizer are as follows......
HCreation (Function)
Creates an empty data file (".FIC" extension) with the index file and the memo file if necessary.
WDConver : Use in interactive mode
Before you start using WDConver, you must have......
iPrintReport (Function)
Prints a report created with the report editor.
16. Java applications in practice
Java applications in practice...
Type of item: Secure password
"Password" items are used to securely store passwords by using a salt and a hash algorithm......
Analysis: Describing data files
The analysis is used to define the structure of data files used by the project......
ODBC driver for HFSQL Classic and for HFSQL Client/Server (Windows)
The ODBC driver for HFSQL Classic (single-user or multi-user) is used to access an HFSQL Classic...
WDInst: installing additional elements
By default, only the files found in the "List of setup files" window are installed on the user...
WINDEV, WEBDEV and WINDEV Mobile tools
The following tools are provided with WINDEV, WEBDEV and WINDEV Mobile...
Additional setup modules
The setup wizard allows you to include additional modules in the setup. The additional modules...
MVP overview: Model - View - Presenter
MVP is the acronym for MODEL - VIEW - PRESENTER......
Managing HFSQL Client/Server databases
The HFSQL Control Center allows you to fully manage HFSQL Client/Server databases......
WLanguage
The integrated WINDEV language, WLanguage, is powerful, simple and intuitive......
Managing the HFSQL servers
The HFSQL Control Center allows you to fully manage HFSQL servers......
OLE DB provider for HFSQL
The OLE DB provider on HFSQL is used to access an HFSQL database (Classic or Client/Server)...
Specific features of the Express version
How to develop a PHP site?
What is a PHP site?......
How to create two linked cascading tables?
This help page explains how to create two linked cascading Table controls in a window or page....
2. Examples provided with WINDEV
The examples provided with WINDEV are intended to help you learn the features of WINDEV....
6. Chart and Pivot Table
WINDEV Tutorial: WINDEV application: Managing data Lesson 6 - Chart and Pivot Table - 30 min
New Features brochure - Version 27: Common new features
New features in WINDEV/WEBDEV/WINDEV Mobile 27 presented in the New Features brochure....
Report based on a query
Queries are used to easily select records in one or more data files......