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.
HDeleteDatabase (Function)
Deletes a database located on an HFSQL server.
HUpdateQuery (Function)
Creates or updates a query on an HFSQL server.
LDAPListChildren (Function)
Lists the children of an object in an LDAP server.
LDAPDisconnect (Function)
Used to disconnect from a specific LDAP server.
LDAPListAttribute (Function)
Lists the object attributes in an LDAP server.
<WBAdminAuth variable>.Disconnect (Function)
Deletes a connection from a WEBDEV Application Server.
HDropView (Function)
Removes a materialized view from the HFSQL server.
RedisSet (Function)
Changes the value of a key on a Redis server.
<redisConnection>.Set (Function)
Changes the value of a key on a Redis server.
WBAdminDisconnect (Function)
Deletes a connection from a WEBDEV Application Server.
<redisConnection>.Connect (Function)
Opens a connection to a Redis server (or cluster).
<Connection variable>.SaveParameter (Function)
Saves a persistent value on the HFSQL server.
<Connection variable>.DeleteDatabase (Function)
Deletes a database located on an HFSQL server.
<Variable Connexion>DeleteView (Function)
Removes a materialized view from the HFSQL server.
FTPCommand (Function)
Sends a specific FTP command to a server.
WebSocketSend (Function)
Sends a message from the WebSocket server to the client.
<WBadminAuth variable>.DeleteApplication (Function)
Deletes an application from a WEBDEV Application Server.
<EmailOutlookSession variable>.GetAll (Function)
Retrieves all the emails found on an Outlook server.
HSaveParameter (Function)
Saves a persistent value on the HFSQL server.
<Connection variable>.UpdateQuery (Function)
Creates or updates a query on an HFSQL server.
<websocketClient variable>.Send (Function)
Sends a message from the WebSocket server to the client.
<EmailNotesSession variable>.GetAll (Function)
Retrieves all the emails found on a Notes server.