ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

<Source>.PrepareSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query.
Database access: summary
WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed....
<Source>.ExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
HPrepareSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query.
Importing tables into the database schema (external database, etc.)
WINDEV and WEBDEV allow you to easily handle external databases (Oracle, SQL Server, Access, etc, ...
HExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
Use WebSockets with the WebSocket server
The WebSocket protocol provides a communication channel over a TCP socket for browsers and Web servers......
SQL statements
The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows......
<Source>.ExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
Client/Server: Connecting client computers to the server
In order for the application to be able to handle the tables found on the HFSQL server, the connection that will be used by the application must be defined in the project......
SQLExecWDR (Function)
Runs the SQL code of a query created in the query editor.
HFConf.Ini file
The HFConf.INI file is found at server root. This file is used to define several characteristics of HFSQL Client/Server server....
Handling files on an FTP server
FTP (File Transfer Protocol) is a protocol for transferring files from one site to another......
CalculatedDefaultValue (Property)
The CalculatedDefaultValue property is used to: Find out the SQL expression that defines the default value of an item. This item was defined in the data model editor or through programming. Define the SQL expression that returns the default value of an item (item described through programming only)....
ODBCSQLCode (Property)
ODBCSQLCode is used to: Find out the SQL code of the "query performed on a connection" (data source of report). Modify the SQL code of the "query performed on a connection" (data source of report)....
CalculatedItemExpression (Property)
The CalculatedItemExpression property is used to: Find out the SQL expression that defines the value of a calculated item. This item was defined in the data model editor or programmatically. Define the SQL expression returning the value of a calculated item (when describing the item through programming)....
How to create an SQL query to get a sum?
This help page explains how to create a Sum query with the query editor....
How to create an SQL query to count?
This help page explains how to create a count query with the query editor....
Remote WEBDEV administrator: Parameters of a WEBDEV site in Session mode or of a Web service
To view the configuration of a specific web service or WEBDEV website in Session mode from the remote administrator:...
appServerScheduledTask (Variable type)
The appServerScheduledTask type is used to manage a scheduled task of WEBDEV Application Server through programming (for a site or a web service).
The DotNet structure