ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

SQL statements
The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows...
Overloading a WLanguage function or using a WLanguage function in an SQL query
WLanguage includes the "WL" keyword...
SQL: Managing joins (INNER JOIN, OUTER JOIN)
To select records coming from several data files, joins must be used in the SQL query...
Creating a query in SQL code
The query editor allows you to create a query by typing SQL code...
SQL selection conditions
To specify the selection conditions in an SQL query, you can use...
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...
SQL commands available in an SQL query
WINDEV allows you to easily run queries in SQL code...
MariaDB Native Connector: Features and notes
This page presents the main aspects and requirements of the Native MariaDB Connector...
CodeGetCSSDeclarations
Returns a CSS style sheet corresponding to a WLanguage code theme.
Note: This function is only available from version 2026 - Update 1.
<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.
HExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
<SQLCodeFormatting variable>.Format (Function)
Applies formatting to SQL code: syntax highlighting, style standardization, etc.
Note: This function is only available from version 2026 - Update 1.
<Source>.ExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
Native MariaDB Connector for WINDEV and WEBDEV
WINDEV and WEBDEV offer a Native Access Connector to MariaDB ...
SQLCodeFormat (Function)
Applies formatting to SQL code: syntax highlighting, style standardization, etc.
Note: This function is only available from version 2026 - Update 1.
1
13