ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Overloading a WLanguage function or using a WLanguage function in an SQL query
WLanguage includes the "WL" keyword...
SQL commands available in an SQL query
WINDEV allows you to easily run queries in SQL code...
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 analysis...
Generating SQL scripts
The content of an analysis can be exported in the format of SQL scripts for a specified database (SQL Server, Oracle, ...
SAP ASE Native Connector (Sybase): Programming using SQL functions
The use of SQL functions to handle Sybase data does not require importing the file structure into the analysis...
Progress Native Connector: Programming using SQL functions
The use of SQL functions to handle Progress data does not require importing the file structure into the analysis...
SQL functions for accessing the external databases
List of SQL functions used to access the external databases
MySQL Native Connector: Programming with SQL functions
The SQL functions can be used to handle the MySQL database...
SQLite Native Connector: Programming using SQL functions
The use of SQL functions to handle SQLite data does not require importing the data file structure into the analysis.
Creating a query in SQL code
The query editor allows you to create a query by typing SQL code...
MariaDB Native Connector: Programming using SQL functions
The SQL functions can be used to handle the MariaDB database...
SQL selection conditions
To specify the selection conditions in an SQL query, you can use...
PostgreSQL Native Connector: Programming with SQL functions
You can use SQL functions to handle the PostgreSQL database...
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: Managing joins (INNER JOIN, OUTER JOIN)
To select records coming from several data files, joins must be used in the SQL query...
The different types of browse available in SQL
Two types of browse can be used to browse the result of a query run by SQLExec...
DB2 Native Connector: Programming with SQL functions
The use of SQL functions to handle DB2 data does not require importing the file structure into the analysis...
SQL statements
The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows...
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...
HExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
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...
Native SAP ASE Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer an optional Native SAP ASE Connector...
<Source>.ExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
HExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
Native Informix Connector for WINDEV and WEBDEV
WINDEV and WEBDEV propose an optional Native Connector to Informix (also called Native Access...
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.
<Source>.ExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
How to develop a site for Linux?
The method for developing a site for Linux is identical to the method for developing a site...
Brochure of new features: Common new features
New features in WINDEV/WEBDEV/WINDEV Mobile 28 presented in the New Features brochure....
New Features brochure - Version 28: Common new features
New features in WINDEV/WEBDEV/WINDEV Mobile 28 presented in the New Features brochure....
TableDisplay (Function)
Refreshes a Table or TeeeView Table control from a given position: for a control linked...
Printing a report in WEBDEV
When creating a report, the test of this report can be run from the report editor. You also...
Item Description (Type of variable)
An Item Description variable is used to describe one or more items in a data file programmatically.
Generating the LDM from the CDM
To associate a CDM (Conceptual Data Model) with a project, you must generate the associated LDM...
Logical Data Model (LDM)
A Logical Data Model (LDM) is used to describe the data structures (files, items, ......
Two methods for passing parameters to a query
Two methods can be used to pass parameters to a query with parameters used in a window...
Logical operators
The logical operators are as follows......
HLockRecNum (Function)
Locks a record and restricts the access to this record for all the other applications.
WDTrans: Overview
WDTrans is a tool for canceling transactions......
WDReplic: Overview
...WDReplic is a tool used to manage the replication of data between several computers that use...
Live Data: viewing data in the editors
The "Live Data" is used to view the content of the data files in the controls currently created...
MDL file (kept for backward compatibility): Pattern description
The MDL file is the file used to generate a RAD window......
Native Oracle Connector: Specific features and remarks
Remarks and specific features of the Native Oracle Connector...
HFSQL constants
List of constants used by the HFSQL functions....
Native Sybase Connector: Output value of a stored procedure run on the server
The Native Sybase Connector (also called Native Sybase Access) is used to: specify the input...
Print technical documentation
You can print different technical documentations describing all the elements of the project...
Native Oracle Connector: Running the same query several times
In some cases, it may be useful to run the same query multiple times while modifying one...
Native Sybase Connector: Running the same stored procedure several times
In some cases, it may be useful to execute the same stored procedure multiple times by changing one...
Managing HFSQL Classic data files
The HFSQL Control Center allows you to fully manage HFSQL Classic data files......
WDLog: Overview
The different operations that can be performed with WDLog are as follows......
Using offline sites
WEBDEV allows you to specify that a site or a set of pages can operate in off-line mode (without...
Project description: Files tab
The project description window allows you to configure various elements of your project......