ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

HExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
<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.
<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.
Importing data files into the analysis (external database, etc.)
WINDEV and WEBDEV allow you to easily handle external databases (Oracle, SQL Server, Access, etc.
Database access: summary
WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed....
<redisConnection>.ExecuteCommand (Function)
Executes a command on a Redis server and retrieves the result.
<Connection variable>.RSListConfig (Function)
Lists the replications available on a master HFSQL server.
<Connection variable>.DeleteSet (Function)
Deletes a set of stored procedures from an HFSQL server.
<Connection variable>.DeleteGroup (Function)
Deletes (from the server) a group of users associated with a connection.
<Connection variable>.DeleteDirectory (Function)
Deletes a directory from an HFSQL Client/Server database....
<Connection variable>.DeleteUser (Function)
Deletes a user associated with a connection to the HFSQL server.
AJAXExecute (Function)
Runs a server procedure without refreshing the page.
ERR_NO_WDADMIN
Uploading files
Uploading consists in saving a file located on the user's computer to the Web server......
Remote WEBDEV administrator: Server parameters
The server administrator can define the server parameters via the remote administration tool......
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 correspondences in the linked files......
How to sort the result of a query?
This help page explains how to create a sort query with the query editor....
HModifyTask (Function)
Modifies a scheduled task on the HFSQL server defined by the connection.
gpwGetLDAPInfo (Function)
Retrieves the configuration of the LDAP server used for the User Groupware.
DNSListAddress (Function)
Lists the IP addresses associated with a name in the DNS server.
DNSDeleteAddress (Function)
Deletes a Name/IP Address relation from a DNS server....
SAP functions
List of SAP functions...
HTTPListCertificate (Function)
Lists the client certificates found on the computer to authenticate on a server.
HListParameter (Function)
Returns the list of parameters saved from the stored procedures on the server.
HTransactionIsolation (Function)
Configures the isolation mode of transactions for a connection to an HFSQL server.
HTTPSend (Function)
Sends an HTTP request and waits for the response from the HTTP server.
TelemetryDisable (Function)
Disables the telemetry. The telemetry data is not sent to the server anymore.
hdfsCopyFrom (Function)
Copies a file found on a Hadoop server to the local computer.
hdfsCopyTo (Function)
Copies a file located on the local machine to a Hadoop server.
MQTTConnect (Function)
Used to connect to a MQTT server (also called "Broker").