ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2026

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, ...
<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.
HExecuteSQLQuery (Function)
Initializes a query written in SQL language and declares this query to the HFSQL engine.
HModifyDatabaseProperty (Function)
Modifies the properties of a database located on an HFSQL server.
HDeleteGroup (Function)
Deletes (from the server) a group of users associated with a connection.
<Connection variable>.ModifyDatabaseProperty (Function)
Modifies the properties of a database located on an HFSQL server.
<Connection variable>.InfoDatabaseProperty (Function)
Used to find out the properties of a database on an HFSQL server.
LDAPValidateAdd (Function)
Validates the addition of a new object into an LDAP server.
HDeleteLink (Function)
Deletes an integrity rule between two tables on the server.
HServerWorkingDir (Function)
Returns the path of a temporary directory on the HFSQL server.
WBAdminDeleteAccount (Function)
Deletes a WEBDEV account from a WEBDEV Application Server.
<WBAdminAuth variable>.CreateAccount (Function)
Creates a WEBDEV account on a WEBDEV Application Server.
<Connection variable>.AddLink (Function)
Adds an integrity rule between two files on the server.
<Connection variable>.DeleteSet (Function)
Deletes a set of stored procedures from an HFSQL server.
<Connection variable>.StartServerUpdate (Function)
Used to immediately start the automatic server update.
HDeleteDirectory (Function)
Deletes a directory from an HFSQL Client/Server database....
RESTSend (Function)
Sends a REST request and waits for the server response.
AppListVersion (Function)
Lists the versions available on the reference setup server.
hdfsList (Function)
Lists the content of a directory found on a Hadoop server.
HListDatabase (Function)
Lists the Client/Server databases associated with a connection....
ExecuteDelayedProcedure (Function)
Runs a delayed procedure (in the WEBDEV Application Server).
HDeleteSet (Function)
Deletes a set of stored procedures from an HFSQL server.
<Connection variable>.UpdateSet (Function)
Creates or updates a set of procedures on an HFSQL server.
<Connection variable>.AddTask (Function)
Adds a scheduled task on the server defined by the connection.
<Connection variable>.RSListConfig (Function)
Lists the replications available on a master HFSQL server.
RedisGet (Function)
Gets the value of a key from a Redis server as a string.
MemcacheGet (Function)
Retrieves the values of keys stored on a Memcached server.
<Connection variable>.DuplicateDatabase (Function)
Duplicates the database associated with a connection on an HFSQL server.