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.
HTTPCertificate (Function)
Modifies the client certificate used by default to identify oneself on a server.
HModifyScheduledOptimization (Function)
Modifies a scheduled optimization task on the HFSQL server defined by the connection.
NameServerFile (Property)
The NameServerFile property is used to get the name of the uploaded file on the server.
UploadDeleteAll (Function)
Clears the list of files to upload: no file will be uploaded on the server.
sshSession (Type of variable)
The sshSession type is used to define the characteristics of a connection to an SSH server.
EmailCopy (Function)
Copies an email found in a directory to another directory of an IMAP server.
AppServerRunScheduledTask (Function)
Immediately starts the execution of a scheduled task on a WEBDEV Application Server.
mongoDatabase (Type of variable)
The mongoDatabase type is used to define the characteristics of a database for a MongoDB server.
hbConnection (Type of variable)
The hbConnection type is used to define the characteristics of a connection to a HBase server.
HCheckServerUpdate (Function)
Checks for the latest version of the HFSQL server that can be automatically updated.
<Upload>.DeleteAll (Function)
Clears the list of files to upload: no file will be uploaded on the server.
memcachedConnection (Type of variable)
The memcachedConnection type is used to define the characteristics of a connection to a Memcached server.
<Connection variable>.ActivateServerTrigger (Function)
Re-enables a server trigger that was disabled by HDeactivateServerTrigger.
<gglConnection variable>.ListDocument (Function)
Retrieves the list of documents available on the Google server for the current user.
<websocketClient variable>.Execute (Function)
Executes a global procedure in the context of a client connected to the WebSocket server.
WLanguage procedure called by WebSocketClientConnect
WLanguage procedure ("callback") called by WebSocketClientConnect when the connection to the server is established.
<Source>.InfoFile (Function)
Returns the characteristics of an HFSQL Classic or Client/Server data file....
<Connection variable>.AddScheduledOptimization (Function)
Adds an optimization task of HFSQL Client/Server data files....
<Connection variable>.InfoServerRights (Function)
Allows you to find out the rights granted to a user or group of users on a server.
<Connection variable>.ListScheduledBackup (Function)
Lists the full and differential backups that have been scheduled on HFSQL Client/Server....
<Connection variable>.InfoFile (Function)
Returns the characteristics of an HFSQL Classic or Client/Server data file....
<Connection variable>.InfoFileProperty (Function)
Allows you to find out the properties of a data file located in an HFSQL server.
<Connection variable>.ModifyScheduledOptimization (Function)
Modifies a scheduled optimization task on the HFSQL server defined by the connection.
ConnectionCount (Function)
Returns the number of instances of the WEBDEV site currently run on the server.
HInfoFile (Function)
Returns the characteristics of an HFSQL Classic or Client/Server data file....