ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

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.
<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.
<Source>.ExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
Database access: summary
WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed....
HExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
Importing data files into the analysis (external database, etc.)
WINDEV and WEBDEV allow you to easily handle external databases (Oracle, SQL Server, Access, etc, ...
Check: NNTP connectivity
The monitoring robot will try to connect to the specified NNTP server (news server)......
SQLExec (Function)
Names and runs an SQL query.
Use WebSockets with the WebSocket server
The WebSocket protocol provides a communication channel over a TCP socket for browsers and Web servers......
DNS functions
WDSQL: Converting the structure of an HFSQL database
WDSQL is used to convert the structure of an HFSQL database into SQL script......
Handling files on an FTP server
FTP (File Transfer Protocol) is a protocol for transferring files from one site to another......
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....
Client/Server: Connecting the client computers to the server
In order for the application to be able to handle the data files found on the HFSQL server, the connection that will be used by the application must be defined in the project......
SQL statements
The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows......
The DotNet structure
<Source>.ExecuteSQLQueryAsynchronous (Function)
Executes an SQL query asynchronously.
3. Handling files on an FTP server
FTP (File Transfer Protocol) is a protocol for transferring files from one site to another....
SQLExecWDR (Function)
Runs the SQL code of a query created in the query editor.
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)....
How to create an SQL query to get a sum?
This help page explains how to create a Sum query with the query editor....
The J2EE structure
The following structure is used to pass parameters to a procedure run on a server of J2EE XML Web services......
HDeactivateServerTrigger (Function)
Disables a HFSQL Client/Server server trigger on a server....
<Connection variable>.DeactivateServerTrigger (Function)
Disables a HFSQL Client/Server server trigger on a server....
SaaS administrator
The SaaS administrator is a Web site used to configure and manage the SaaS sites deployed on a WEBDEV Application Server......
How to create an SQL query to count?
This help page explains how to create a count query with the query editor....
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 through programming. Define the SQL expression returning the value of a calculated item (when describing the item through programming)....
Type and version of Web server
The configuration diagnostic displays the following error......
HListServer (Function)
Lists the HFSQL servers installed on a computer.
1
4
5
6
7
8
156
>