ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

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...
PostgreSQL Native Connector: Programming with SQL functions
You can use SQL functions to handle the PostgreSQL database...
SQL commands available in an SQL query
WINDEV allows you to easily run queries in SQL code...
Generating SQL scripts
The content of an analysis can be exported in the format of SQL scripts for a specified database (SQL Server, Oracle, ...
Overloading a WLanguage function or using a WLanguage function in an SQL query
WLanguage includes the "WL" keyword...
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...
Creating a query in SQL code
The query editor allows you to create a query by typing SQL code...
SQL: Managing joins (INNER JOIN, OUTER JOIN)
To select records coming from several data files, joins must be used in the SQL query...
MariaDB Native Connector: Programming using SQL functions
The SQL functions can be used to handle the MariaDB database...
SQL statements
The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows...
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 database schema...
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...
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 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...
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...
Mathematical SQL functions
The mathematical SQL functions that can be used on the queries written in SQL code are as follows...
SQL selection conditions
To specify the selection conditions in an SQL query, you can use...
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)...
SQLite Native Connector: Programming using SQL functions
The use of SQL functions to handle SQLite data does not require importing the table structure into the database schema.
MariaDB Native Connector: Features and notes
This page presents the main aspects and requirements of the Native MariaDB Connector...
Native Informix Connector for WINDEV and WEBDEV
As an option, WINDEV and WEBDEV offer an Informix Native Connector (also known as Native Access...
Extensions of files created by WINDEV, WEBDEV, WINDEV Mobile
Main file extensions created and managed by WINDEV, WEBDEV and WINDEV Mobile...
HExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
<Source>.ExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
<Variable CodeSQLMiseEnForme>MetEnForme (Function)
Applies formatting to SQL code: syntax highlighting, style standardization, etc.
Versions 2026 and later
Note: This function is only available from version 2026 - Update 1.
Subscription-exclusive new feature
Note: This function is only available from version 2026 - Update 1.
New in version 2026
Note: This function is only available from version 2026 - Update 1.
Note: This function is only available from version 2026 - Update 1.
<Source>.ExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
PostgreSQL Native Connector: Features and notes
Remarks and specific features of Native PostgreSQL Connector...
SQLCodeFormat (Function)
Applies formatting to SQL code: syntax highlighting, style standardization, etc.
Versions 2026 and later
Note: This function is only available from version 2026 - Update 1.
Subscription-exclusive new feature
Note: This function is only available from version 2026 - Update 1.
New in version 2026
Note: This function is only available from version 2026 - Update 1.
Note: This function is only available from version 2026 - Update 1.
HExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
MySQL Native Connector: Features and notes
Remarks and specific features of the Native MySQL Connector
CodeGetCSSDeclarations
Returns a CSS style sheet corresponding to a WLanguage code theme.
Versions 2026 and later
Note: This function is only available from version 2026 - Update 1.
Subscription-exclusive new feature
Note: This function is only available from version 2026 - Update 1.
New in version 2026
Note: This function is only available from version 2026 - Update 1.
Note: This function is only available from version 2026 - Update 1.
Native Progress Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer an optional Native Connector to Progress ...
DB2 Native Connector: Features and notes
The following paragraphs present the main aspects and specific features of the Native DB2 Connector...
Native DB2 Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer an optional Native Connector to DB2...
Native Informix Connector: Requirements and remarks
Remarks and specific features of Native Informix Connector
Native MariaDB Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer a Native Access Connector to MariaDB ...
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.
Native MySQL Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer a Native Connector for MySQL...
Native SAP ASE Connector: Requirements and remarks
The following paragraphs present the main aspects and specific features of the Native SAP ASE Connector (also called Native Sybase Access)...
Native Oracle Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer an optional Native Oracle Connector (also called Native Oracle Access...
Native SAP ASE Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer an optional Native SAP ASE Connector...
Native PostgreSQL Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer a Native Connector to PostgreSQL...
<Source>.PrepareSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the database server in order...
HPrepareSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the database server in order...
Creating a delete query
A delete query (corresponding SQL statement......
Configuring the connection with WDSQSINS
For compatibility with the earlier versions of the Native SQL Server Connector (also called Native...
Multi-database queries
A query (typed in SQL code) can operate on different databases......
Creating an update query
An Update query (SQL UPDATE statement) is used to modify the records in a database file......
Handling data files in PHP
WEBDEV allows you to create a PHP site that handles data files......
Sub-query
A sub-query is a query whose result is used by another query......
How to create a query with external join?
In SQL language, an external join is used to exclude or include file records with or without...
How to sort the result of a query?
This help page explains how to create a sort query with the query editor....
HConnect (Function)
Redefines one or more connection parameters via Native Connector (Access, SQL Server, MySQL...
Check: Connectivity to the external databases (by ODBC)
The monitoring robot will attempt to connect to an external database (MySQL, SQL Server, ......
Handling a database from a Java application
You can start developing your application as soon as the WINDEV project is defined as being a Java...
How do I run a table with a filter?
How to discover WINDEV Mobile?...
Database access: summary
WINDEV and WEBDEV support different SQL query execution modes depending on how the database...
1
4
5
6
7
8
24
>