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.
HSetCache (Function)
Used to configure the management of caches in the HFSQL Client/Server engine....
FTPConnect (Function)
Connects the current computer to an FTP server (File Transfer Protocol).
FTPSend (Function)
Transfers a file or directory to an FTP server (File Transfer Protocol).
HInfoServerRights (Function)
Allows you to find out the rights granted to a user or group of users on a server.
HInfoFileProperty (Function)
Allows you to find out the properties of a data file located in an HFSQL server.
HTransactionList (Function)
Returns the list of current or interrupted transactions on the server for the specified connection.
WLanguage procedure called by WebSocketClientConnectSSL
WLanguage procedure ("callback") called by WebSocketClientConnectSSL when the connection to the server is established.
<Connection variable>.TransactionList (Function)
Returns the list of current or interrupted transactions on the server for the specified connection.
<Connection variable>.CheckServerUpdate (Function)
Checks for the latest version of the HFSQL server that can be automatically updated.
<Source>.ChangePassword (Function)
Changes the password of an HFSQL Classic or HFSQL Client/Server table....
memcachedConnection (Variable type)
The memcachedConnection type is used to define the characteristics of a connection to a Memcached server.
<Connection variable>.ListScheduledBackup (Function)
Lists the full and differential backups that have been scheduled on HFSQL Client/Server....
GglListDocument (Function)
Retrieves the list of documents available on the Google server for the current user.
DNSAddAddress (Function)
Adds an "IP address/domain name" pair to the DNS server....
EmailCopy (Function)
Copies an email found in a directory to another directory of an IMAP server.
WLanguage procedure called by WebSocketClientConnect
WLanguage procedure ("callback") called by WebSocketClientConnect when the connection to the server is established.
<websocketClient variable>.Execute (Function)
Executes a global procedure in the context of a client connected to the WebSocket server.
AppDeleteVersion (Function)
Deletes a version from the history of versions found on the reference setup server.
mongoDatabase (Variable type)
The mongoDatabase type is used to define the characteristics of a database for a MongoDB server.
HTTPCertificate (Function)
Modifies the client certificate used by default to identify oneself on a server.
<Connection variable>.ActivateServerTrigger (Function)
Re-enables a server trigger that was disabled by HDeactivateServerTrigger.